PRB: Error Message: "Could Not Load Translator or Setup Library"


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."


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.


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 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:
    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:


    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:

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:

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:


For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

307255 INFO: Component Checker: Diagnose and Reconfigure MDAC Installations
232060 HOWTO: MDAC Setup Troubleshooting Guide
243069 INFO: List of Useful MDAC Setup Related Articles

Article ID: 260558 - Last Review: Feb 11, 2009 - Revision: 1