ID: 29524 Updated by: [EMAIL PROTECTED] Reported By: fadi at netways dot com -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 5.0.0 -Assigned To: +Assigned To: tony2001 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip There were some thread safety related changes. Please, try a snapshot. Previous Comments: ------------------------------------------------------------------------ [2004-08-12 05:02:38] vincomaldini at hotmail dot com I've had this SAME problem on two different machines with W2K spk4, Oracle 9.2.0.1 and IIS. It seems that any attempt to use OCILogon or oci_connect causes the script to hang indefinitely and not close the HTTP connection. ------------------------------------------------------------------------ [2004-08-04 14:21:22] fadi at netways dot com Description: ------------ Platform: ========= PHP 5.0 (Release) Windows 2000 server IIS 6.0 (PHP runs as ISAPI module) Oracle 9i Client Tools (Admin) ORACLE_HOME correctly set as system variable Oracle Databae 9i installed on a separate reachable server (i tested sqlplus). IUSR_XXXX has correct permissions to C:\PHP and C:\Oracle\Ora92 directories. IMPORTANT: Simply replacing PHP 5 with PHP 4.3.4 works Reproduce code: --------------- <?php $dbConnString = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST = myserver)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mydb)))"; $conn = OCILogon('username', 'password', $dbConnString); if( $conn ) echo "Connected:" . OCIServerVersion( $conn ); else { echo "Not Connected"; exit(); } $query = "SELECT * FROM LoginBackOffice"; $statement = OCIParse ($conn, $query); OCIExecute ($statement); while (OCIFetchInto ($statement, $row, OCI_ASSOC)) { echo "<hr>"; print_r( $row ); } ocilogoff( $conn ); ?> Expected result: ---------------- 2 rows of data!!!! Actual result: -------------- Script hangs indefinitly ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=29524&edit=1
