Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


ODBC Error In Windows XP Professional

Posted on 2002-05-24
Medium Priority
Last Modified: 2007-11-27
I just installed Windows XP Professional.

I go into the ODBC manager and try to view the Configure for any driver loaded and get an error:

"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver could not be loaded due to a system error code 126."

You click Ok and a second error pops up:

"Could not load the setup or translator library."

This may not be an Office error, because I get the same error on any driver I try to view, with the driver's application name displaying respective to it's application.

This started by noticing that anything I tried to run went through a routine of the Windows Installer trying to install Outlook 2000.

I have loaded Office 97, and then Outlook 2000.

Outlook already works with no problems, but the Windows Installer routine runs with the message box title saying that it's trying to load Outlook 2000.  It errs out, and you have to cancel the install, because it automatically restarts the install and errs out each time.

I then tried to run Visual Basic 6.0, and the same Windows Installer file ran for Outlook 2000.

I then removed Outlook 2000 and reloaded it, but the problem remains.

I now can't open MS Access, but the other office products will load.

I then removed Office 97 completely and reinstalled, but I am getting the same problem.

I then reloaded XP Professional hoping that maybe there was a glitch when installing the ODBC stuff the first time, but I'm getting the same error.

This means that I can't use any software using ODBC.

Can anyone tell me if you had this problem, or if you know what to do.  I'd really appreciate any help at all.

This was a fresh install on a newly formatted drive.


Question by:RichW
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
LVL 44

Expert Comment

ID: 7032616
Probably the best place to start is to completely uninstall both MS Office Suites and VB starting with VB. Then reboot and uninstall the Office 2000 stuff reboot and then uninstall Office 97 and reboot again. Now if you still intend to use anything in Office 97 then reinstall it first and reboot then install any of the Office 2000 you want and reboot an then install VB 6.0. Basically you need to try an clear out everything from these installs and start fresh. Test the ODBC after uninstalling and before reinstalling.

The Crazy One
LVL 44

Expert Comment

ID: 7032619
Of course backup all your data files related to these products.
LVL 16

Expert Comment

ID: 7033118
1. So have you loaded both Office 97 and Office XP on the same machine?
If so what order and which directories?
2. What does your log say under applications - and system?
There should be errors with event ID's and source to further isolate the problem.
start |  run   type    eventvwr.msc

The ODBC is no biggie - but first you have to have Office installed correctly and have no problems with installer.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 44

Expert Comment

ID: 7033149
Note the following MS KB may not address your situation specifically with Outlook 2000 but this may help get you past the Windows Installer problem.

Download the Windows Installer CleanUp Utility from the following Microsoft Web site:
Then run Windows Installer CleanUp Utility to clean up all entries for the OEM version of Office.

Insert the Office 2000 CD-ROM into the drive, and then follow the installation instructions.

Restart the computer, and then start and configure Outlook.

By Using Registry Editor
WARNING : Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT or Windows 2000, you should also update your Emergency Repair Disk (ERD).

Click Start , point to Settings , and then click Control Panel .

Click Add/Remove Programs , click Office 2000, Small Business Edition , and then click Add/Remove .

Click Remove Office , and then follow the instructions for removing the program.

Start Registry Editor (Regedt32.exe).

For each of the following registry keys, locate the key, click Edit , click Delete , and then click Yes :

HKEY_CURRENT_USER\Software\Microsoft\Installer\Products\ OfficeGUID
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Installer\Products\ OfficeGUID
HKEY_LOCAL_MACHINE\Software\Classes\Installer\Products\ Office GUID
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall\ Office GUID
Locate the following key in the registry:

On the Registry menu, click Export Registry File , type a file name, and then click Save .

On the Edit menu, click Delete , and then click Yes .

Quit Registry Editor.

In Windows Explorer, locate and delete the following folders:

hard disk drive :\Program Files\Microsoft Office
hard disk drive :\Program Files\Common Files\Microsoft Shared\Stationery
hard disk drive :\Windows\Msagent
Run the Office 2000 File and Registry Eraser Utility for Microsoft Office CD1 (Eraser2000.exe) or the Office 2000 File and Registry Eraser Utility for Microsoft Office CD2 (Eraser2000a.exe), and then restart the computer.

Insert the Office 2000 CD-ROM in the drive, and then follow the installation instructions...
LVL 25

Accepted Solution

dew_associates earned 1600 total points
ID: 7034174

You should be able to resolve this by correct some registry entries and then updating the MDAC DLL files to the most current versions.

First, the reg changes. Remember, you must be logged on as an administrator!

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" (without the quotation marks) 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.
Now, to resolve the incompatible .dll files problem:
Reinstall your current version of MDAC, or install the latest version. I would suggest downloading the newest version. The latest version of MDAC can be downloaded from the following Microsoft Web site:

You may also want to review view these articles in the Microsoft Knowledge Base:
Q307255 INFO: Component Checker: Diagnose and Reconfigure MDAC Installations
Q232060 HOWTO: MDAC Setup Troubleshooting Guide
Q243069 INFO: List of Useful MDAC Setup Related Articles


Author Comment

ID: 7034306
Thanks everybody.  My company closed yesterday at noon for the US holiday.  I will take all comments into consideration and make any comments or questions on Monday.

Food for thought:  I only have Office 97 installed, because that's what the client uses.  I have Windows XP Professional OS installed.

I have loaded MDAC 2.7.

I have already completely uninstalled VB and Office and reinstalled both in different orders each time twice.

It's definately an ODBC problem.  Something is stepping on the dlls during an install, but I just have to figure out what application is doing that.

Have a great weekend/holiday everyone.  I will get back on Monday.

LVL 41

Expert Comment

ID: 7035161
found this
and from MS
PRB: Error Message: "Could Not Load Translator or Setup Library" (Q260558)

Author Comment

ID: 7038984
Thanks, Dennis.  There were registry errors that once fixed solved the problem.  Must have been a simple glitch during installation of the OS, because it was a fresh install.  

Incidentally, I went back from MDAC 2.7 to 2.5 as well.

Thanks everyone else for all your help.

LVL 25

Expert Comment

ID: 7040893
Glad I could help Rich!

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Disclosure: Use this tutorial only when no other options helps to get Windows XP running without any problems and you don't want to format the drive. The back up of the data is the responsible of the user, however there is a description of how t…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question