RES: PHP4 / WinNT 4 / Oracle 7.3 via ODBC
| From: | Carlos Correa Goncalves | Date: | Tue, 23 Jan 2001 17:05:26 +0000 |
| Subject: | RES: PHP4 / WinNT 4 / Oracle 7.3 via ODBC | ||
| Groups: | php.db php.windows | ||
| Request: | Send a blank email to php-windows+get-5157@lists.php.net to get a copy of this message | ||
Hi all,
Thanks a lot for the help!! I´ve reinstalled Oracle Cliente (version
8.1.5.0.0) and PHP 4.0.4pl1 and tried Jean-Christophe suggestion, with
success:
----------
<?php
putenv("ORACLE_SID=badm");
putenv("ORACLE_HOME=D:\ORANT");
$tns = "(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =
bhz_oracle_1)(PORT = 1521))) (CONNECT_DATA = (SID = badm) ) )";
$connect=OCIPLogon("user","password",$tns) or die("It's not possible
to
connect");
$sql = "select * from CentrosCusto";
$result = OCIParse($connect,$sql);
OCIExecute($result) or die("It's not possible to query");
echo("<TABLE>");
while(OCIFetch($result)) {
$CC = OCIResult($result,1);
$CCNome = OCIResult($result,2);
echo('<TR><TD>' . $CC . '</TD><TD>' . $CCNome .
'</TD></TR>');
}
echo("</TABLE>");
?>
-------------
Then let's start the real job... I am in the game!
Bye
> ----- Mensagem original -----
> De: Carlos Correa Goncalves
> Enviada em: Sexta-feira, 19 de Janeiro de 2001 13:53
> Para: 'php-windows@lists.php.net'; 'php-db@lists.php.net'
> Assunto: PHP4 / WinNT 4 / Oracle 7.3 via ODBC
>
> Hi,
>
> I´m using PHP 4.0.4pl1 with extension php_oracle.dll, Oracle client 7.3
> with the following products installed:
> -------------------------
> Call Interface 7.3.4.0.0
> Objects for OLE 2.2.1.0.0
> 32 bit ODBC 2.5.3.1.0B
> Support files 7.3.4.0.0
> SQL*Net Client 2.3.4.0.0
> ... and others
> ------------------------------
>
> I´m trying to connect to an Oracle 7.3 database with ODBC functions or
> direct connection. Those are the code:
>
> ---------------
> putenv("ORACLE_SID=badm");
> putenv("ORACLE_HOME=C:\ORANT");
> putenv("TNS_ADMIN=C:\ORANT\NETWORK\ADMIN");
>
> $connect = ora_logon("usercons@badm","sylkds");
> ----------------
> putenv("ORACLE_SID=badm");
> putenv("ORACLE_HOME=C:\ORANT");
> putenv("TNS_ADMIN=C:\ORANT\NETWORK\ADMIN");
>
> $connect = odbc_connect("badm" ,"consulta","consulta");
> ---------------
>
> Both are returning the following message from PHP:
> Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve
> service name in oracle.php on line xxx
> Any suggestion?
>
>
>
>