How to solve the problem of missing mysql odbc installation

Solution to the missing mysql odbc installation: First use Notepad to create a new file other.rsp; then save the contents of "INSTALLDRIVER MySQL ODBC 5.3.6..."; then run odbcconf.exe; finally create a new file A DSN test is enough.

Recommended: "mysql video tutorial"

ODBC driver loss solution

Today When running SqlDbx to connect to the database, an error occurred, indicating that the corresponding ODBC driver was not found. When I opened the ODBC management panel, I found that all the drivers inside were missing.

At this time, I remembered that after uninstalling a cost accounting software today, it became like this. After searching online, I only need to use odbcconf.exe to re-register the ODBC Driver.

Registration method:

There are several script files in the %systemroot%\System32 directory, which can be used to complete the driver registration:

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

But after registration, I found that there were no more SQL Server Native Client and MySQL Connector/ODBC are two drivers that existed before uninstallation. It is not necessary to reinstall them.

Later I opened rsp and saw the text content. I thought I could just create a new one to register these two drivers.

Use Notepad to create a new file other.rsp, save the following content

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 After registration, open the ODBC management panel and see that these two drivers are back. Create a new DSN to test and everything is OK!

The above is the detailed content of How to solve the problem of missing mysql odbc installation. For more information, please follow other related articles on the PHP Chinese website!