Software

Ask something
Discussion Locked

ADO Connection string for MySQL DB

0 helpful
2 replies

by lump_16

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all,
I currenlty have a VB program that works with data on an Access DB using ADO.

I have the same data on a MySQL DB but ma having trouble with the connect string.

Any help or suggestions would be appreaciated.

Thanks,
Brian Wright
http://www.wright-onthe-web.com

2 replies

by ajunod

Look for myOdbc. myOdbc will install a mySql odbc driver that you should be able to connect to through ADO.

by overloaded

download myodbc 3.51 from mysql.com and then attemp connection string to the ado object with the odbc driver (little bit slower) or try to buy an oldb from a third party devewloper for visual basic, in case you want to be connecting natively to the database

This discussion is closed to new replies.