Cannot load OCI DLL: oci.dll.
Posted: Wed 19 Jul 2006 16:20
Hi,
I have same problem as ganand.
OS: windows xp x64
IDE: Delphi 7, Delphi 2006
ODAC: 5.70.1.32, 5.70.1.33, 5.70.1.34
Oracle: 10.2.0.1.0
OCI: Version 10.2.0.1.0 (not loaded)
DLL: oci.dll
Current Home:
Call style:
Oracle:
When try connect ODAC said: Cannot load OCI DLL: oci.dll.
SQL Plus and other aplication connect well.
PATH=C:\oracle\product\10.2.0\client_1\bin;C:\Program Files (x86)\Borland\Delphi7\Bin;C:\Program Files (x86)\Borland\Delphi7\Projects\Bpl\;C:\oracle\product\10.
2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="C:\Program Files\Oracle\Inventory"
"VOBHOME2.0"="C:\oracle\product\10.2.0\client_1"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1]
"ORACLE_HOME"="C:\oracle\product\10.2.0\client_1"
"ORACLE_HOME_NAME"="OraClient10g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraClient10g_home1"
"ORACLE_BUNDLE_NAME"="Enterprise"
"NLS_LANG"="RUSSIAN_CIS.CL8MSWIN1251"
"OLEDB"="C:\oracle\product\10.2.0\client_1\oledb\mesg"
"StmtCacheSize"="0"
"SQLPATH"="C:\oracle\product\10.2.0\client_1\dbs"
"ORACLE_HOME_KEY"="SOFTWARE\ORACLE\KEY_OraClient10g_home1"
"MSHELP_TOOLS"="C:\oracle\product\10.2.0\client_1\MSHELP"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1\OLEDB]
"CacheType"="Memory"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRset"="0"
"PwdChgDlg"="1"
"SchRstLng"="10000"
"UserDefFn"="0"
"DisableRetClause"="1"
"VCharNull"="1"
"TraceCategory"="0"
"TraceFileName"="c:\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"
"SPPrmDefVal"="0"
"StmtCacheSize"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1]
"ORACLE_HOME"="C:\oracle\product\10.2.0\db_1"
"ORACLE_HOME_NAME"="OraDb10g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraDb10g_home1"
"NLS_LANG"="RUSSIAN_CIS.CL8MSWIN1251"
"ORACLE_BUNDLE_NAME"="Enterprise"
"OLEDB"="C:\oracle\product\10.2.0\db_1\oledb\mesg"
"StmtCacheSize"="0"
"MSHELP_TOOLS"="C:\oracle\product\10.2.0\db_1\MSHELP"
"SQLPATH"="C:\oracle\product\10.2.0\db_1\dbs"
"ORACLE_HOME_KEY"="SOFTWARE\ORACLE\KEY_OraDb10g_home1"
"ORACLE_BASE"="C:\oracle\product\10.2.0"
"RDBMS_CONTROL"="C:\oracle\product\10.2.0\db_1\DATABASE"
"RDBMS_ARCHIVE"="C:\oracle\product\10.2.0\db_1\DATABASE\ARCHIVE"
"ORA_DB3_AUTOSTART"=hex(2):54,52,55,45,00
"ORA_DB3_SHUTDOWN"=hex(2):54,52,55,45,00
"ORA_DB3_SHUTDOWNTYPE"=hex(2):69,6d,6d,65,64,69,61,74,65,00
"ORA_DB3_SHUTDOWN_TIMEOUT"=hex(2):39,30,00
"ORACLE_SID"="DB3"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB]
"CacheType"="Memory"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRset"="0"
"PwdChgDlg"="1"
"SchRstLng"="10000"
"UserDefFn"="0"
"DisableRetClause"="1"
"VCharNull"="1"
"TraceCategory"="0"
"TraceFileName"="c:\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"
"SPPrmDefVal"="0"
"StmtCacheSize"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN]
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsoleDB3]
"EMDROOT"="C:\oracle\product\10.2.0\db_1"
"ORACLE_HOME"="C:\oracle\product\10.2.0\db_1"
"EMSTATE"="C:\oracle\product\10.2.0\db_1\ST_syb.home.LOCAL_DB3"
"CONSOLE_CFG"="dbconsole"
"ORACLE_SID"="DB3"
"TIMEOUT"="15"
"TRACE_LEVEL"="16"
I have same problem as ganand.
OS: windows xp x64
IDE: Delphi 7, Delphi 2006
ODAC: 5.70.1.32, 5.70.1.33, 5.70.1.34
Oracle: 10.2.0.1.0
OCI: Version 10.2.0.1.0 (not loaded)
DLL: oci.dll
Current Home:
Call style:
Oracle:
When try connect ODAC said: Cannot load OCI DLL: oci.dll.
SQL Plus and other aplication connect well.
PATH=C:\oracle\product\10.2.0\client_1\bin;C:\Program Files (x86)\Borland\Delphi7\Bin;C:\Program Files (x86)\Borland\Delphi7\Projects\Bpl\;C:\oracle\product\10.
2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="C:\Program Files\Oracle\Inventory"
"VOBHOME2.0"="C:\oracle\product\10.2.0\client_1"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1]
"ORACLE_HOME"="C:\oracle\product\10.2.0\client_1"
"ORACLE_HOME_NAME"="OraClient10g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraClient10g_home1"
"ORACLE_BUNDLE_NAME"="Enterprise"
"NLS_LANG"="RUSSIAN_CIS.CL8MSWIN1251"
"OLEDB"="C:\oracle\product\10.2.0\client_1\oledb\mesg"
"StmtCacheSize"="0"
"SQLPATH"="C:\oracle\product\10.2.0\client_1\dbs"
"ORACLE_HOME_KEY"="SOFTWARE\ORACLE\KEY_OraClient10g_home1"
"MSHELP_TOOLS"="C:\oracle\product\10.2.0\client_1\MSHELP"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1\OLEDB]
"CacheType"="Memory"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRset"="0"
"PwdChgDlg"="1"
"SchRstLng"="10000"
"UserDefFn"="0"
"DisableRetClause"="1"
"VCharNull"="1"
"TraceCategory"="0"
"TraceFileName"="c:\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"
"SPPrmDefVal"="0"
"StmtCacheSize"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1]
"ORACLE_HOME"="C:\oracle\product\10.2.0\db_1"
"ORACLE_HOME_NAME"="OraDb10g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraDb10g_home1"
"NLS_LANG"="RUSSIAN_CIS.CL8MSWIN1251"
"ORACLE_BUNDLE_NAME"="Enterprise"
"OLEDB"="C:\oracle\product\10.2.0\db_1\oledb\mesg"
"StmtCacheSize"="0"
"MSHELP_TOOLS"="C:\oracle\product\10.2.0\db_1\MSHELP"
"SQLPATH"="C:\oracle\product\10.2.0\db_1\dbs"
"ORACLE_HOME_KEY"="SOFTWARE\ORACLE\KEY_OraDb10g_home1"
"ORACLE_BASE"="C:\oracle\product\10.2.0"
"RDBMS_CONTROL"="C:\oracle\product\10.2.0\db_1\DATABASE"
"RDBMS_ARCHIVE"="C:\oracle\product\10.2.0\db_1\DATABASE\ARCHIVE"
"ORA_DB3_AUTOSTART"=hex(2):54,52,55,45,00
"ORA_DB3_SHUTDOWN"=hex(2):54,52,55,45,00
"ORA_DB3_SHUTDOWNTYPE"=hex(2):69,6d,6d,65,64,69,61,74,65,00
"ORA_DB3_SHUTDOWN_TIMEOUT"=hex(2):39,30,00
"ORACLE_SID"="DB3"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB]
"CacheType"="Memory"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRset"="0"
"PwdChgDlg"="1"
"SchRstLng"="10000"
"UserDefFn"="0"
"DisableRetClause"="1"
"VCharNull"="1"
"TraceCategory"="0"
"TraceFileName"="c:\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"
"SPPrmDefVal"="0"
"StmtCacheSize"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN]
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsoleDB3]
"EMDROOT"="C:\oracle\product\10.2.0\db_1"
"ORACLE_HOME"="C:\oracle\product\10.2.0\db_1"
"EMSTATE"="C:\oracle\product\10.2.0\db_1\ST_syb.home.LOCAL_DB3"
"CONSOLE_CFG"="dbconsole"
"ORACLE_SID"="DB3"
"TIMEOUT"="15"
"TRACE_LEVEL"="16"