#29524 [Fbk->NoF]: Trying to connect to an oracle 9i Db, script hangs, same script on PHP4 works
ID: 29524
Updated by: php-bugs@lists.php.net
Reported By: fadi at netways dot com
-Status: Feedback
+Status: No Feedback
Bug Type: OCI8 related
Operating System: Windows 2000
PHP Version: 5.0.0
Assigned To: tony2001
New Comment:
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
Previous Comments:
------------------------------------------------------------------------
[2004-08-13 17:41:39] tony2001@php.net
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.
------------------------------------------------------------------------
[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
Thread (4 messages)