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:
[5152]hantam88 | Login Resmi Situs Slot Gacor Hari Ini Terpercaya,hantam88 menyediakan akses login resmi dengan pilihan download apk mudah. Temukan pola slot pragmatic play terbaru dan kemudahan deposit via dana. Daftar sekarang! visit: hantam88