(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.
CGI the application on IIS is runing out under user IUSR_<name> which has no rights of access to the catalogue %RACLE_HOME%\bin. Look Security tab in properties of a folder %RACLE_HOME%
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...