Accessing Oracle 8i using ODBC
| From: | William Cheung | Date: | Wed, 04 Dec 2002 18:05:29 +0000 |
| Subject: | Accessing Oracle 8i using ODBC | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-9309@lists.php.net to get a copy of this message | ||
I got the following error when I test Oracle 8i connection with ODBC.
Application popup: php.exe - Application Error : The instruction at
"0x77f853ca" referenced memory at "0x00000010". The memory could not be
"read".
Click on OK to terminate the program
Click on CANCEL to debug the program
I am using Win2K and PHP 4.2.3. The ODBC connection is working fine with
other applications.
The following is my test script.
<?php
$conn_ptr = odbc_connect("DB","user","password");
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);
?>
It outputs the datarows and then the error pops up. Please tell me what
causes the problem. The above script works fine with SQL Server
database.
William Cheung, B.Sc. MCSE MCDBA
Databyte Corp.