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:
