Reprint: MySQL ODBC under 64-bit prompt cannot find ODBC driver problem

On a 64-bit machine, if you want to connect to 32-bit MySQL, you will typically install MySQL CONNECTOR/ODBC 64-bit and connect properly in the configuration of ODBC data source tests, but when the program is connected, such as ASP, ASP, net, VB, Delphi and other software to access the database, You are not prompted to find the ODBC driver.

This is a lot of information on the Internet, many developers even abandon the use of MySQL database, or in other development languages such as PHP instead.

I tried most of the day, and finally found a solution to the problem: because you use the 32-bit MySQL, then you should use 32-bit ODBC configuration Manager, instead of the system menu default 64-bit ODBC configuration, find the 32-bit ODBC Configuration tool under Windows\syswow64\ Odbcad32.exe, run it, and then configure the DSN you want. Final program connection, test OK.

Originating from:http://jingyan.baidu.com/article/4d58d5413043a09dd4e9c021.html

Reprint: MySQL ODBC under 64-bit prompt cannot find ODBC driver problem