Re: OCI8 broken in CGI, but works in ISAPI?

Koos Vriezen wrote: > I'm having this problem too: I can't get OCI8 connecting to a database with > php.exe, while the ISAPI module can. I tried recompiling php myself linking > again my own oci libraries, upgrading my oracle client to 8.1.5, but nothing > works. > Is it not strange that from the same compilation the CGI version behaves > differently than the ISAPI module? Koos, 1) Is your client 8.1.5 or 8.1.6? oci8 extension for php4 is compiled for 8.1.6 Oracle client specifically. Try upgrading again to 8.1.6.... if you meant 8.1.6, then we'll work from there. 2) How have you defined your Net8 service for this database... perhaps include a bit from your tnsnames.ora and your php script that doesn't work in CGI. 3) Try running the script OUTSIDE the web server, on a command line... go to the directory of your oracle php script and type "c:\php\php.exe myscriptname.php"... do you get the same error message? It's not so strange that the ISAPI filter might work, and CGI not... I know that with just a few configuration problems, I could get oci8 working under CGI, but NOT under Apache module. Filters/modules and the CGI executable work in very different ways. -- Andy Hoffman Web Developer Bristol-Myers Squibb email: andy.hoffman@bms.com