Misc: Data source name not found and no default driver specified – ODBC / MySQL

Misc: Data source name not found and no default driver specified – ODBC / MySQL

Error: Data source name not found and no default driver specified

Platform: Windows7 (64 bit), MS Office 2010 (32 bit)

After downloading and installing the ODBC driver from oracle.com for 64 bit, this is the error observed when trying to access a MySQL server via Micrsoft Word VBA using a connection string:

conn.connectionString = "Driver={MySL ODBC 5.1 Driver};Server=10.1.1.10;Database=contacts; User=admin;Password=qwerty1"

Solution: The key issue here is that you must you must install the db drivers corresponding to the architecture of the application which is to use them, i.e.:

If you have 32 bit MS Office you MUST install the 32 bit MySQL drivers, if you have a 64 bit release then you MUST install the 64 bit drivers. There is absolutely no harm in installing both!

Notes: To access the 64 bit ODBC manager, pull up “Data Sources (ODBC)” from the start menu, to access the 32 bit manager, run the following: “C:\Windows\SysWOW64\odbcad32.exe

In the ODBC managers, make sure that you have the drivers installed:

Data source name not found and no default driver specified

 

 

Leave a Reply