RE: [PHP-DB] Problems with Oracle connections

2001-03-29 Thread Brian Hardwick 

I belive you have to set your sid and oracle_home before attempting to
ora_logon?

putenv("ORACLE_SID=your sid);
putenv("ORACLE_HOME=your oracle home);

if(ora_plogon("rascunho@dvfpmm","java"))
{ echo "conectou"; }
else
{ echo "falhou outra vez:".ora_error(); }")

-Original Message-
From: bgadelha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 8:37 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problems with Oracle connections


Hi,
I'm having troubles using PHP+Oracle.
Im under Win98, with Apache WebServer, PHP4 and Oracle.
When I try to connect, the following error message is
displayed:

Warning: Unable to connect to ORACLE (ORA-12154:
TNS:could not resolve service name) in
c:\apache\htdocs\testeoracle.php on line 24
falhou outra vez:ORA-12154: TNS:could not resolve
service name

Here is my code:

?php

if(ora_plogon("rascunho@dvfpmm","java"))
{ echo "conectou"; }
else
{ echo "falhou outra vez:".ora_error(); }

phpinfo(INFO_ENVIRONMENT);

?

Can somebody help me?

Thanks
Bruno.


__
O BOL  Top3 no iBest! Vote j para torn-lo Top1!
http://www.bol.com.br/ibest.html



--
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 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]

Re: [PHP-DB] Problems with Oracle connections

2001-03-29 Thread houston 

Have you tried supplying the optional third parameter to ociplogon() to
specify the connection?

ociplogon( "username","password","tns_alias");

--Houston

""bgadelha"" [EMAIL PROTECTED] wrote in message
Hi,
I'm having troubles using PHP+Oracle.
I´m under Win98, with Apache WebServer, PHP4 and Oracle.
When I try to connect, the following error message is
displayed:

Warning: Unable to connect to ORACLE (ORA-12154:
TNS:could not resolve service name) in
c:\apache\htdocs\testeoracle.php on line 24
falhou outra vez:ORA-12154: TNS:could not resolve
service ...



-- 
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]