ODBC connection error - 1114

[ddrillich]

Good Day,

When trying to get connected to Oracle 10G via an ODBC driver I get the following error -

Error: "Unable to make connection: State: IM003 NativeError: 160 Message:Specified driver could not be loaded due to system error 1114 (Oracle in OraClient10g_home2)."

There is a very similar thread with no reply is at -

http://www.tek-tips.com/viewthread.cfm?qid=1116907

Any ideas?

Regards,
Dan

 

[karluk]

Metalink note 1029911.6 says that this error can be caused by a failure to find the OCI.DLL file in your ORACLE_HOME\bin directory. The suggested fixes are to (1) add ORACLE_HOME\bin as the first library to be searched in your PATH environment variable or (2) navigate to the ORACLE_HOME\bin directory before executing the ODBC driver.

But be forewarned: I also see enough unresolved threads on this issue in Metalink to suggest that this problem is not always easy to fix.

 

[ddrillich]

Hi karluk,

Thank you for your response.

A server reboot was needed. We found a couple of references that pointed in this direction.

Many thanks.

Regards,
Dan