=========
QUESTION
———
When attempting to ADD or EDIT an ODBC connection from the ODBC Data Source Administrator in Windows, I receive the following error:
Microsoft ODBC Administrator
The setup routines for the X ODBC Driver could not be loaded due to system error code 126: The specified module could not be found. (C:……dll).
=========
ANSWER
———
The path to the ODBC driver which is listed in the Registry is incorrect.
To repair, edit the registry as follows:
Open the Registry Editor (click the Start button in Windows, select Run, type: REGEDIT, click OK)
Locate the following key:
HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INI
Look for the corresponding key named for the driver you are working with, and select that key.
Look at the Driver and Setup strings on the right.
Now open Windows Explorer and attempt to browse to those paths in your file system.
Chances are you will not be able to.
For example, you may have
C:WINNTsystem32sqlsrv32.dll
listed, when in fact your system has the driver at
C:WINDOWSsystem32sqlsrv32.dll
Edit each String to the correct file path, and you will no longer experience Error 126
=========
EXAMPLES
———
see ANSWER
=========
APPLIES TO / KEY WORDS
———
ODBC
Database
Connection
File Path
=========
REF
———
http://support.microsoft.com/kb/260558
—
http://www.anysitesupport.com/odbc-error-the-setup-routines-for-the-x-odbc-driver-could-not-be-loaded/
http://anySiteHosting.com