Click to See Complete Forum and Search --> : PHP - Oracle -Netscape Enterprise Server


rwoods
05-07-2001, 02:11 PM
I am trying to setup PHP 4.0.4/Oracle on a WinNT using the Netscape Enterprise Server.
I've chosen to run the php scripts as cgi and configured the web server to handle cgi as a file type.
I can run simple PHP scipts (phpinfo, hello world, etc) without a problem; but the scripts that attempt to connect to the Oracle db fail with the standard TNS error.
If I run the same Oracle script, on the web sever, from a command prompt window it connects. So I don't have a 'connectivity problem' from the web server; the problem appears to be in 'environment' of the Netscape Enterprise Server.
I've seen several posts with Apache configuration settings; but none for Netscape Enterprise.
Does anyone know the format to set the ORACLE global settings in the web servers and which file to put them into on a Netscape Enterprise 3.x web server?

Thanks,
Ron Woods

Anon
05-07-2001, 05:11 PM
Which "standard TNS error"? Most likely you mean TNS-12154, but there are a number of other common ones.

If you are running PHP as a CGI, then most of the Apache-related information should apply. In other words, make sure that your ORACLE_HOME, ORACLE_SID and/or TWO_TASK have been set correctly for the userID which the CGI is run as.

If you need futher help, let me know. If you really cannot figure it out, I can help you troubleshoot the problem further over the phone or via e-mail.

-- Michael
Darkstreak Consulting
www.darkstreak.com