VB and MYSql

amen

Afternoon,
I was wondering has anybody ever used MySQL with VB ?
Any tips/hints on setting MySql up ?

e

CH

http://www.mysql.com/doc/en/Installing.html

Evil Phil

There is a version of mySql for windows if memory serves which means theres an ODBC driver. Once you've istalled mySql then setup a DSN to the database and connect to it from VB using ADO.

RicardoSmith

I'm running it with PHP on a IIs box. I haven't got around to trying to get VB to talk to it, but it was something I was planning to do aswell.

amen

well I have it up and running now
fairly painless install

using a 3rd party tool called NavCat which gives a nice GUI

now to get the insert/updates/selects working

no SQL Stored Procedures though

RicardoSmith

Originally posted by amen
well I have it up and running now
fairly painless install

using a 3rd party tool called NavCat which gives a nice GUI

now to get the insert/updates/selects working

no SQL Stored Procedures though

Any links to NavCat?

Evil Phil

Apparently there plans to include stored procedures in MySQL v. 5 - God knows when that will be released. They won't be supporting triggers though.

I'd also like a link to NavCat, prrrease.

amen

here u go

http://www.mysqlstudio.com/shareware.php3

just click on the download button

how do does eveyone store their sql statements ?
in a dll, text file ?
the paramaters of the sql will change each time the sql is called