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

Hi, >Florian Clever wrote: >> Hi, >> > >I just noticed something interesting. I have the same PHP script trying > >to connect to Oracle via OCI8. When run through the ISAPI module it will > >connect + return proper data, but with CGI it returns Warning: ORA is > >unable to resolve TNS. Using SQLPlus I am also able to connect. > > > >The configuration is the exact same for both scripts (same server (but > >.php as ISAPI and .phtml as CGI)): > >WinNT 4 SP6a, IIS 4, PHP4.0.2 from php4win.de. >Question, how do you have your Oracle Service identified for this particular >database instance... (check Net8 Assistant). Make sure that you are using >Oracle 8.0 Compatible Service Identification - defines connections by older >SID instead of the new SERVICE NAME convention. 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? Regards, Koos Vriezen