Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: oci.dll not found
oci.dll not found
Posted: 2000/08/10 11:06
 
Hello Dmitry,

I'm in troubles again After installing one of the Oracle product I got the following error anytime I try to use NOCI: "Exception EOCIDBError in module NCO85.bpl... Error while loading OCI.dll. The system cannot find the file specified"

I even tried to reistall Oracle client, and NOCI, but didn't succeed.

Could you give me an algorithm how NOCI looks for noci.dll.

Thank you !
Leonid
RE: oci.dll not found
Posted: 2000/08/10 12:34
 
Hi Leonid !

The algorythm is easy ...
NCOCI8 walks through all Oracle home, that are recorded in registry in next order:
HKLMSoftwareOracle
HKLMSoftwareOracleHome0
.....
HKLMSoftwareOracleHomeN
And try to get value of ORACLE_HOME of each home. Then appends BIN to that path, and search it in environment variable PATH. The Oracle home and it BIN directory, that is first in PATH will be used by NCOCI8. In that BIN directory NCOCI8 try to load OCI.DLL or value of ORAOCI.

It seems, that you did not have valid BIN directory in PATH or some problems with registry structure.

If my hint will be wrong, please send to me next information:
- server & client versions;
- NCOCI8 version;
- export of HKLMSoftwareOracle;
- value of PATH variable.
RE: oci.dll not found
Posted: 2000/08/11 08:15
 
Thank you !

I found the reason. In my case OCI takes SoftwareOracleOracle_Home.
By the way, is it right ? I don't know.
RE: oci.dll not found
Posted: 2000/08/11 10:02
 
It seems, that you have Oracle client software v <= 8.0.5 and it is installed into Oracle home, that is selected as primary (if you have more than one oracle home). If you have only single Oracle home, than it is primary allways.