Shulou(Shulou.com)06/01 Report--

This article will explain in detail what to do about the missing installation of mysql odbc. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Solution to missing mysql odbc installation: first create a new file other.rsp; with notepad and then change "INSTALLDRIVER MySQL ODBC 5.3.6." Save the content; then run odbcconf.exe; and finally create a new DSN test.

Solution to the loss of ODBC driver

Today, I reported an error when running SqlDbx to connect to the database, indicating that I could not find the corresponding ODBC driver. When I opened the ODBC management panel, I found that all the drivers inside were gone.

Then think of today after uninstalling a cost accounting software like this, online search only need to use odbcconf.exe to re-register ODBC Driver on it.

Registration method:

There are several script files in the% systemroot%\ System32 directory to complete the driver registration:

Odbcconf.exe / S / Lv odbcconf.log / F% systemroot%\ system32\ odbcconf.rspodbcconf.exe / S / Lv odbcconf.log / F% systemroot%\ system32\ mdaccore.rspodbcconf.exe / S / Lv odbcconf.log / F% systemroot%\ system32\ sqlclnt.rspodbcconf.exe / S / Lv odbcconf.log / F% systemroot%\ system32\ redist.rsp

However, after registration, it is found that there is no SQL Server Native Client, MySQL Connector/ODBC, the two drivers that exist before uninstallation, it will not be reinstalled.

Later, open rsp to see the text content, want to create a new one to register these two drivers on the line.

Create a new file other.rsp with notepad and save the following

INSTALLDRIVER "MySQL ODBC 5.3.6 Unicode Driver | Driver=myodbc5w.dll | Setup=myodbc5s.dll |" INSTALLDRIVER "MySQL ODBC 5.3.6 ANSI Driver | Driver=myodbc5a.dll | Setup=myodbc5s.dll |" INSTALLDRIVER "SQL Server Native Client 10.0 | Driver=sqlncli10.dll | |"

Then run odbcconf.exe / S / Lv odbcconf.log / F% systemroot%\ system32\ other.rsp to register, open the ODBC management panel and see that the two drivers are back, and create a new DSN to test everything OK!

On the missing installation of mysql odbc how to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.