Hi Carlos,
I had the same problem with a configuration near yours.
PHP4.04
WinNT4
IIS4
Oracle client 8.0
I've used OCI fonctions, because they work with Oracle client 8.0 (my data
base is in Oracle 7.3.4.00 but it works well)
Here is my PHP code :
// You can find the connection string in the file tnsnames.ora, this is the
only solution i've find to connect to my distant database
$Connection="(DESCRIPTION = (ADDRESS = (PROTOCOL = ...)(HOST = ...)(PORT =
...))(CONNECT_DATA = (SID = ...)))";
// under Windows NT this file is under [Oracle
Client]\Net80\Admin\Tnsnames.ora
// This is a permanent connection
$Oracle=OCIPLogon(user, passowrd, $Connection);
// sample of query
$Requete=OCIParse($Oracle, "select ALTI from POSTE order by COMMUNE");
// the ALTI field is store in the $Alti variable
OCIDefineByName($Requete,"ALTI",&$Alti);
// execute the query
OCIExecute($Requete);
// read all the rows
while (OCIFetch($Requete))
{
echo $Alti
}
Don't forget the line
extention=php_oci8.dll in your PHP.ini if you work under Windows NT, with
LINUX you must make your PHP with the OCI8 librairie i think...
Maybe you can try to yse $Connection with
Oracle = Oracle_Logon($User, $Password, $Connection);
I've tried to use odbc_connect (ODBC was ok), but it doesn't work, i don't
know why...
Good luck
Jean-Christophe Le Brun
Météo-France
CMIRNE/DET
03-88-40-42-46
[EMAIL PROTECTED]
--
PHP Windows 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]
