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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.