Sorry but I am not using Linux and Apache and also I didn't compile the source myself. My system is a Win2K server running IIS 4.0. I have just upgrade it to PHP 4.3.4 but it doesn't help. The test script has been used for Oracle 8i without problem. I have test the ODBC connection and also the command line and both works fine. I have used php.exe and php4isapi.dll in the web server and both return the same error. William Cheung B.Sc, MCSE, MCDBA Databyte Corp. -----Original Message----- From: Justin Patrin [mailto:papercrane@xxxxxxxxxxxxxxx] Sent: January 15, 2004 11:53 AM To: php-db@xxxxxxxxxxxxx Subject: Re: PHP4.2.3 and Oracle 9.2 > Error display on browser: > > Warning: SQL error: Specified driver could not be loaded due to system > error 5 (Oracle in OraHome92)., SQL state IM003 in SQL Connect in > c:\inetpub\wwwroot\PHP\testora.php on line 2. > > Warning: odbc_exec(): Supplied argument is not a valid ODBC-Link > resource in c:\inetpub\wwwroot\PHP\testora.php on line 5 > > Warning: odbc_fetch_into(): Supplied argument is not a valid ODBC result > resource in c:\inetpub\wwwroot\PHP\testora.php on line 6 > > Warning: odbc_close(): Supplied argument is not a valid ODBC-Link > resource in c:\inetpub\wwwroot\PHP\testora.php on line 14 > If you're using seperate PHP compilations for command-line and Apache (ie. a php binary for CLI and mod_php for apache) then it is likely that the same things were not compiled into both. Of course, since this is ODBC, it seems unlikely that this is the problem. It's probably some kind of ODBC configuration issue. Check the documentation for ODBC on Linux and make sure that the web version of PHP has the correct settings (use phpinfo()). -- paperCrane <Justin Patrin> -- Question Everything, Reject Nothing -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 1/08/2004 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
