Oracle ODBC

[joeythelips]

hI,

I'm trying to create an ODBC link to an Oracle database.
I have a windows 2000 machine and when i select Oracle ODBC driver, i get the following message:
"The setup routines for the ODBC DRIVER ODBC driver could not be loaded due to system error code 126"

If somone can help me overcome thsi problem it would be much appreciated.

Joe

 

[rcurva]

Make sure you are logged in as administrator to set this up.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[joeythelips]

Hi Robbie.

Thanks for your help.
Unfortunately your idea is not the solution as I am the administartor of this machine.
I have also discovered that old Oracle ODBC connections i made are not working today.

 

[mrBB]

Make sure the path (environment var) is set correctly to your Oracle home and the java component in Program Files (see a fresh install for details)....

 

[Guest_imported]

Joe, any luck with this? I'm getting the same error message. Thanks.

 

[karluk]

Take a look at the following Microsoft documentation:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q260558

As you can see, the documentation says that this error can be caused by either incorrect register settings or incompatible dlls. Perhaps your ODBC driver isn't compatible with Windows 2000.

 

[Andronium]

try re-loading MDAC... I had this problem and that fixed it.

 

[bookouri]

Thats the major problem I have had every time Ive depended on odbc connections. They just seem to "break" without warning... reloading mdac might fix it, or you might have to uninstall everything first and then reload mdac.. but next week it might all just break again....