Error Message -- `Could Not Load Translator or Setup Library`

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

The information in this article applies to:

Microsoft Data Access Components 2.0
Microsoft Data Access Components 2.1
Microsoft Data Access Components 2.5

This article was previously published under Q260558

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

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 .

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

Driver could not be loaded due to system error code 1157.

These message may include a driver name, such as "Microsoft Access Driver {*.mdb}"

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

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Resolution for incorrect registry settings problem:

Start Registry Editor (Regedit32.exe).

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.

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://www.microsoft.com/data

REFERENCES

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

Referenced by...

Error Message -- Could Not Load Translator or Setup Library