Hi,
Use the OCI functions (see the html help) with the TNS like it is in your
tnsnames.ora file (C:\ORAWIN\NETWORK\ADMIN\TNSNAMES.ORA):
<?php
putenv("ORACLE_SID=java");
putenv("ORACLE_HOME=C:\ORAWIN");
$tns = "(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =
oracleserver)(PORT = 1521)))
(CONNECT_DATA = (SID = java) ) )";
$Conn=OCIPLogon("user","password",$tns) or die("Can not connect to Oracle");
?>
Bye
Carlos
> ----- Mensagem original -----
> De: bgadelha [SMTP:[EMAIL PROTECTED]]
> Enviada em: Quinta-feira, 29 de Março de 2001 10:37
> Para: [EMAIL PROTECTED]
> Assunto: [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]
--
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]
