Visual Basic 6.0 & SQL Server 2000....

[Reid]

hello people,
I m using Visual Basic 6.0 & SQL Server 2000, and looking to migrate to MySQL. please advice, can my VB application connected to MySQL database via ADO conn? How the connection string to connecting to MySQL?
Is Ms SQL Server 2000 the same as MySQL.
Thank You Very Much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Yadira]

download and install MyODBC driver from mysql.com and use this connectionstring

connectionstring = "driver=mysql odbc 3.51 driver;" & _
"server=serverIP;" & _
"database=dataname;" & _
"port=3306;" & _
"uid=root;" & _
"pwd=pwdofroot"

hope it will work for you. Good Luck! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --