While I am trying to add a DSN Entry on the SYSTEM DSN tab
in the ODBC Data Source Administrator, receive the
following error message "The setup rotuines for the sql
server odbc driver could not be loaded due to system error
code 126". Can anyone help me on this.

Thanks,

Dan Baker

>-----Original Message-----
>While I am trying to add a DSN Entry on the SYSTEM DSN
tab
>in the ODBC Data Source Administrator, receive the
>following error message "The setup rotuines for the sql
>server odbc driver could not be loaded due to system
error
>code 126". Can anyone help me on this.
>
>Thanks,
>
>Dan Baker
>.
>Try to install mdac 2.7 you can find it at
http://www.microsoft.com/downloads/search.aspx?
displaylang=en this should take care of it and it might be
good idea to download the mdac utility component checker
as well. The Component checker allows you to uninstall
mdac and reinstall it.

Hi Dan,

Thanks Gary for his help. Based on my research, it looks like there is
something wrong with the registry for the drivers. We will need to check
the registry first before we reinstall any MDAC components.

Please perform the following steps to check and correct the registry for
the drivers.

1. Open Registry Editor (Start' Run' Type "regedit").
2. Traverse down to the following key
HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\SQL Server.

3. Verify that both the Driver and Setup parameters point to the correct
path of
sqlsrv32.dll. If the existing values are not correct, then edit the path
with the exact location of the sqlsrv32.dll.

Does it resolve your problem? If not, please try to install the latest
version of MDAC. For additional information regarding MDAC, please refer to
the following article:

Microsoft Data Access Components (MDAC) 2.7 Service Pack 1 Refresh
http://www.microsoft.com/downloads/d...0f2-cae7-493d-
b0f3-ae36c570ade8&DisplayLang=en

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.