php-db | 2001051

[PHP-DB] The Dreaded Oracle 8 TNS:ORA-12154 Connection Error From: Paul (pauls <email protected>)
Date: 05/07/01

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

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 <email protected>","pass"))
{
echo "SUCCESS ! Connected to database\n";
Ora_Logoff($conn);
}
else
{
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
Apache.

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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>