Accessing MySQL throughVisual Basic 6

[codo]

Any idea how to access mySQL using visual basic? i tried to make connection with ODBC but it seems couldn't find the driver.

 

[johnwm]

I notice that you have asked a number of questions but you haven't found any of the answers helpful or valuable to you. You may benefit from reading faq222-2244 to see how to get the best answers from this forum (as I mentioned to you last October)

To connect VB to mySQL using ODBC look here for the connection string:

http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForMySQL

You will need the appropriate ODBC driver from mySQL:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[codo]

Thanks for your info.

 

[johnwm]

You're welcome

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[QatQat]

The ODBC driver for MySQL is available for download at

http://www.mysql.com.

Using VB6 though I recommend MyOLEDB and a connectionstring like

Provider: MySQLProv
Data Source: SERVER=ZEUS;DB=database_name;UID=user_name;PWD=password;PORT=3128


Cheers

Qatqat





Life is what happens when you are making other plans.