OBDC link to mySQL for MS Access use

Ray Pinnegar · #1 (**permalink**) May 16th, 2005, 04:12 AM

I am trying to set up a mySQL OBDC link to mySQL using the Windows Data Sources tool. However, there is no driver listed.
Anyone know how to plug one in, or the ADODB connection string to access mySQL from within VBA?

Cheers Ray

mmcdonal · #2 (**permalink**) May 16th, 2005, 08:44 AM

Hi,

I think you need to go here: http://dev.mysql.com/downloads/connector/odbc/3.51.html

mmcdonal

Ray Pinnegar · #3 (**permalink**) May 17th, 2005, 03:37 AM

Thanks - worked a treat!!
Don't suppose you know the coonection string for OLEDB connection?

Cheers Ray

Need to download code?

Navigation