System Error 126 for ODBC configuration

April 10, 2008 at 3:20 pm (Tech - Others)

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.

 

Permalink Leave a Comment

Rich Internet Applications – An overview

January 23, 2008 at 8:52 am (Tech - Others) ()

A consolidation of interesting things available about RIA on net. Click here to have a look at the document. RIA.

Permalink Leave a Comment