RE: [PHP-WIN] PHP4 / WinNT 4 / Oracle 7.3 via ODBC

First an ignorant remark/question (which really have nothing to do with your current problem): The subject line says "... Oracle 7.3 ...", and you are trying to communicate with this server via a DLL for Oracle version 8.x(?). Is this DLL backwards compatible with Oracle version 7.x? About your problem: 1) Does it really refers to slashes ('/') in the file name? Should it not be back slashes ('\')? 2) If the path is syntactical correct, does the DLL file exist in that directory? 3) If the DLL exists, does it have proper access rights? Is the file corrupted somehow? Etc, etc... >-----Original Message----- >From: Carlos Correa Goncalves [mailto:correa@bhz.sarah.br] >Sent: Monday, January 22, 2001 1:00 PM >To: 'php-windows@lists.php.net' >Subject: RES: [PHP-WIN] PHP4 / WinNT 4 / Oracle 7.3 via ODBC > > >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:jean-christophe.lebrun@meteo.fr] >> Enviada em: Segunda-feira, 22 de Janeiro de 2001 05:40 >> Para: Carlos Correa Goncalves; >php-windows@lists.php.net >> 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 >> jean-christophe.lebrun@meteo.fr >> > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >For additional commands, e-mail: php-windows-help@lists.php.net >To contact the list administrators, e-mail: >php-list-admin@lists.php.net >