I am running PHP 4.0.4pl1 in CGI mode on Windows NT4 SP6, using Apache or IIS Web 

I am concentrating on Apache for this problem as it is identical irrespective of the 
Web Server.

I'm using one of the simplest possible connection mechanisms ...

if ($conn=Ora_Logon("user@mydatabase","pass"))
echo "SUCCESS ! Connected to database\n";
echo "Failed :-( Could not connect to database\n";

This works fine if PHP is run as an apache module but fails with the message 

"Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in 
c:\program files\apache group\apache\htdocs\ora.php on line 10"

When Apache is re-configured to run PHP as CGI (other html on the same page suce as 
phpinfo() shows up just fine).

At first I thought the Apache user may have been affecting privileges but the Apache 
"User" option doesn't work under Windows & I even tried running Apache as a service 
using the Administrator
account - no change. Have tried environment paths to ORACLE_HOME, TNS_PATH etc. etc. 
etc. all to no avail. We use sqlnet.ora with an oracle name server.

I have to use CGI as PHP4 isn't to production level for use as a Filter with IIS & 
corporate policy dictates that I must prove PHP against ASP on the existing IIS server 
before I can even attempt using

I would greatly appreciate any construction :-) advise anyone can offer.

Regards, Paul Shortis

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to