[PHP-DB] Problems with Oracle connections
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 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]
RE: [PHP-DB] Problems with Oracle connections
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
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]