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: This messages may be accompanied by one of the following error messages: 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:

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:For the Microsoft ODBC for Oracle driver, the registry key, the path, and the DLLs are the following:

Resolution for incompatible .dll files problem:

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