[PHP-DB] The Dreaded Oracle 8 TNS:ORA-12154 Connection Error
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@mydatabase,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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] The Dreaded Oracle 8 TNS:ORA-12154 Connection Error
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@mydatabase,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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
