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).
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:
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
listed, when in fact your system has the driver at
Edit each String to the correct file path, and you will no longer experience Error 126
APPLIES TO / KEY WORDS