Cannot load OCI.DLL
hendrtiOct 8 2007 — edited Oct 8 2007Hello all
I installed an oracle database 10G and an oracle client 10g on my demo server.
Also did I install TOAD 8.0 but when I load it and I want to connect to my database it gives following error:
Cannot load OCI DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
These are the messages that are giving in the connect using options screen:
SOFTWARE\ORACLE (Oracle Root)
ORACLE_HOME_NAME:
ORACLE_HOME:
ORACLE_SID:
NLS_LANG: American_America.AL32UTF8
SQLPATH:
LOCAL:
Home directory does NOT exist!
Home is NOT valid!
Instant Client - 10.2.0.1.0
ORACLE_HOME_NAME: C:\oracle\product\10.2.0\client_1\bin
ORACLE_HOME: C:\oracle\product\10.2.0\client_1\bin
ORACLE_SID:
NLS_LANG: American_America.AL32UTF8
SQLPATH:
LOCAL:
C:\oracle\product\10.2.0\client_1\bin exists.
C:\oracle\product\10.2.0\client_1\bin is in PATH.
Client DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
Client Version: 10.2.0.1.0
Home is NOT valid!
Instant Client - 10.2.0.1.0
ORACLE_HOME_NAME: C:\oracle\product\10.2.0\db_1\bin
ORACLE_HOME: C:\oracle\product\10.2.0\db_1\bin
ORACLE_SID:
NLS_LANG: American_America.AL32UTF8
SQLPATH:
LOCAL:
C:\oracle\product\10.2.0\db_1\bin exists.
C:\oracle\product\10.2.0\db_1\bin is in PATH.
Client DLL: C:\oracle\product\10.2.0\db_1\bin\oci.dll
Client Version: 10.2.0.1.0
Home is NOT valid!
It says that the Home is not valid although it is correctly defined.
Can anyone help me with this problem?
thanks!