Hi Jean-Christophe,
Thanks for your help! I´ve tried your suggestion. When I add
"extention=php_oci8.dll" to the php.ini and restart the www service, I get
the message:
------
PHP Warning: Unable to load dynamic library 'd:/php4/php_oci8.dll' - The
specified module could not be found. in Unknown on line 0
----
The library is in the correct folder. May it be a problem with version of
php_oci8.dll? But it´s been unzipped from the same file as the php.exe
which is running.
Bye
> ----- Mensagem original -----
> De: Jean-Christophe Le Brun
> [SMTP:[EMAIL PROTECTED]]
> Enviada em: Segunda-feira, 22 de Janeiro de 2001 05:40
> Para: Carlos Correa Goncalves; [EMAIL PROTECTED]
> Assunto: Re: [PHP-WIN] PHP4 / WinNT 4 / Oracle 7.3 via ODBC
>
> 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]
