MySQL ODBC is not prompted for ODBC driver issues under 64-bit

On a 64-bit machine, if you want to connect 32-bit MySQL, you will typically install MySQL CONNECTOR/ODBC 64-bit and connect properly in the configuration of the ODBC data source test (and I didn't actually test it successfully ...). ), but in the program connection, such as ASP, ASP. NET, VB, Delphi and other software access to the database, but it is 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, please C:/WINDOWS/SYSWOW64 Under Find the 32-bit ODBC Configuration tool Odbcad32.exe, run it, and then configure the DSN that you want. Final program connection, test OK.

MySQL ODBC is not prompted for ODBC driver issues under 64-bit