#29524 [Opn->Fbk]: Trying to connect to an oracle 9i Db, script hangs, same script on PHP4 works

From: Date: Fri, 13 Aug 2004 15:41:41 +0000
Subject: #29524 [Opn->Fbk]: Trying to connect to an oracle 9i Db, script hangs, same script on PHP4 works
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-64559@lists.php.net to get a copy of this message 
 ID:               29524
 Updated by:       tony2001@php.net
 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

Thread (4 messages)

« previous php.bugs (#64559) next »