System Error 126 for ODBC configuration
In a Windows XP machine, when you are trying to configure DSN using ODBC, you might the following error.
The setup routines for SQL Server ODBC driver could not be loaded due to system error code 126.
The ODBC driver name can change depending upon the driver, which you are trying to configure. To resolve this issue, open registry and goto Hkey_Local_Machine\Software\ODBC\ODBCINST.INI\SQL Server
In the above case, click on SQL Server folder inside ODBCINST.INI. The folder can vary depending on the driver which you are trying to configure.
Change Driver and Setup path to have system32 rather than system in its value.
Now you should be able to configure your DSN successfully.
Note: Take a backup of the registry key before making any changes.
Advertisement
