When porting a server, because the environment also needs to be transplanted, but the ODBC registry configuration and the installed office are pilot, an error is reported, and the enterprise manager and ODBC cannot be opened.
The following error occurs: "the SQL Server ODBC driver cannot be loaded.ProgramBecause of system errors.Code126 "," cannot load the installation or converter library ", what should I do?
Later, we only need to use odbcconf.exe to re-register the ODBC driver.
There are several script files in the Windows/system32 directory to complete the registration of the driver:
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/odbcconf. RSP
Odbcconf.exe/S/LV odbcconf. log/F % SystemRoot %/system32/redist. RSP
Copy and run the registration in sequence.