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]