|
I am using PHP 4.2.3 and Oracle 9.2. I have a test file that runs successfully in command line. But when I use a browser to open the file, it gives SQL error. Could anyone give me any insight what could be wrong?
Testora.php: <?php $conn_ptr = odbc_connect(“ORACLEDB”,”USERID”,”USERPASSWORD”); print $conn_ptr.”\r\n”; ob_flush(); $SQLReturn = odbc_exec($conn_ptr,”SELECT company_name FROM company”); $ReturnRows = odbc_fetch_into($SQLReturn,$line,1);
while ($ReturnRows){ print $line[0].”\r\n”; ob_flush(); $ReturnRows = odbc_fetch_into($SQLReturn,$line); }
odbc_close($conn_ptr); ?>
Command line output: Resource id #1 Company name list…
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
William Cheung B.Sc, MCSE, MCDBA
---
|
