Could not locate OCI dll

[Dmitriy]

(DOA 3.4.6 and Oracle 9.2.0.1 MS IIS 5)
CGI the application does not work in this configuration, but works with Oracle 8.1.x

When OracleSession.Connected := True;
there Is a message on a mistake:

OracleHomeKey: SOFTWARE\ORACLE\HOME0 OracleHomeDir: G:\oracle\ora92 Content-Type: text/html Content-Length: 295 Content:
Internal Server Error 500
-----------------------------------
Exception: EReadError
Message: Error reading OracleSession1.Connected: Initialization error Could not locate OCI dll OracleHomeKey: SOFTWARE\ORACLE\HOME0 OracleHomeDir: G:\oracle\ora92
+++++++++++++++++++++++++++++++++++
Variables Path, ORACLE_HOME are established correctly. There is only one ORACLE_HOME
Help me.

 

[Dmitriy]

CGI the application on IIS is runing out under user IUSR_ which has no rights of access to the catalogue %RACLE_HOME%\bin. Look Security tab in properties of a folder %RACLE_HOME%

 

[Janus]

I have i thing the same problem, i have made a CGI in Delphi7 that opens a connection to Oracle 8.1.7 with DOA. when i execute this CGI.exe from my command prompt it works fine, when i execute this CGI.EXE with MSIE i get the describet error.

I'm running a Apache 2 ..

Can anyone tell me how to pass the right enviroment to this CGI session, i think this is the problem...

PLEASE HELP !

 

[Janus]

Hi again,,, i managed it, just by installing the Oracle client localy on the machine, instead of on a netword server..

Now it just works fine !!

i didn't even have to use passenv og setenv settings in httpd.conf