Could not locate OCI.dll

[argenta]

Hello,

When I want to connect to oracle i get the following error message. The delphi app. is een isapi dll to provide web-pages for the users.

Error: Error reading OracleSession1.Connected: Initialization error
Could not locate OCI dll

OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: D:\oracle\ora92

Can someone help me.

Thanks

[This message has been edited by argenta (edited 25 August 2003).]

 

[Marco Kalter]

Is there an Oracle Net installation (OCI.DLL file) in D:\oracle\ora92\bin? It would seem that this is not the case.

------------------
Marco Kalter
Allround Automations

 

[argenta]

Yes the file is in the Orcale dir.

Originally posted by mkalter:
Is there an Oracle Net installation (OCI.DLL file) in D:\oracle\ora92\bin? It would seem that this is not the case.

 

[Marco Kalter]

What is your Direct Oracle Access version? Can you also let me know if D:\oracle\ora92\bin is in the PATH environment variable?

------------------
Marco Kalter
Allround Automations

 

[argenta]

I reinstalled the server and the oracle client and know everything works fine.
Thanks for the reply's.

Originally posted by mkalter:
What is your Direct Oracle Access version? Can you also let me know if D:\oracle\ora92\bin is in the PATH environment variable?

 

[Kit]

There are a couple posts like this and it seems that this is essentially a NTFS Security issue. Because IIS executes ISAPI applications under a different user, the permissions of the different user are enforce. I found that when I installed Oracle, it didn't give full permissions to the Oracle directories to the IIS user, which caused exectly the error message posted above.

My suggestion is to go in and ensure your IIS user has full access to your Oracle directory.

 

[al0]

Originally posted by Kit:
...
My suggestion is to go in and ensure your IIS user has full access to your Oracle directory.

Full access Oracle directory for IIS user is inadvisable for security reasons (really, only DBA users have to have full access), but read access is definitely required.