DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 260558 - Last Review: February 11, 2009 - Revision: 4.0

This article was previously published under Q260558

On This Page

SYMPTOMS

When you install any software that tries to change the ODBC configuration or install ODBC components, such as Microsoft Data Access Components, service packs, or Microsoft Access, or you configure an ODBC data source through the ODBC Administrator, the following error message appears:
Could not load translator or setup library.
This messages may be accompanied by one of the following error messages:
Unable to configure ODBC driver <driver name>.

The setup routines for the <driver name> could not be loaded due to system error code 126.

Driver could not be loaded due to system error code 1157.
These messages may include a driver name, such as "Microsoft Access Driver {*.mdb}," "SQL Server," or "Microsoft ODBC for Oracle ODBC driver."

CAUSE

There are two possible causes for this problem:
  • Incorrect registry settings for MDAC components.
  • Incompatible .dll files.
These problems may have arisen because of an installation of older software that changed the registry settings of the ODBC drivers or replaced some .dll files with incompatible versions.

RESOLUTION

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756  (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows

Resolution for incorrect registry settings problem:

  1. Start Registry Editor (Regedt32.exe).
  2. Locate the following key in the registry:
    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
    Installation information for ODBC drivers is stored in this key. Make sure that all the required ODBC driver files are in the correct folder as described by the registry keys. For example, assume that you have the following information in your registry for the Microsoft Access ODBC driver:
    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)

    Driver = C:\WINNT\System\Odbcjt32.dll
    Setup = C:\WINNT\System\Odbcjt32.dll
    This will cause an error if the Odbcjt32.dll file is in the C:\WINNT\System32 folder. You can modify the registry key values to C:\WINNT\System32\odbcjt32.dll to solve this problem. Also verify that the Odbcinst.ini file has the correct entries in the same way.

    Any wrong value in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI under the Setup key will cause this error.
For the SQL Server ODBC driver, the registry key, the path, and the DLLs are the following:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server

Driver = C:\WINNT\system32\SQLSRV32.dll
Setup = C:\WINNT\system32\sqlsrv32.dll
For the Microsoft ODBC for Oracle driver, the registry key, the path, and the DLLs are the following:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft ODBC for Oracle

Driver = C:\Windows\System32\msorcl32.dll
Setup = C:\Windows\System32\msorcl32.dll

Resolution for incompatible .dll files problem:

Reinstall your current version of MDAC, or install the latest version. See the "References" section of this article for more information on reconfiguring an MDAC installation. The latest version of MDAC can be downloaded from the following Microsoft Web site:
http://msdn.microsoft.com/en-us/data/aa937729.aspx (http://msdn.microsoft.com/en-us/data/aa937729.aspx)

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
307255  (http://support.microsoft.com/kb/307255/EN-US/ ) INFO: Component Checker: Diagnose and Reconfigure MDAC Installations
232060  (http://support.microsoft.com/kb/232060/EN-US/ ) HOWTO: MDAC Setup Troubleshooting Guide
243069  (http://support.microsoft.com/kb/243069/EN-US/ ) INFO: List of Useful MDAC Setup Related Articles

APPLIES TO
  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
Keywords: 
kbdatabase kbprb KB260558
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support