mssql_query stucks my Script

From: Date: Wed, 07 Aug 2002 10:48:17 +0000
Subject: mssql_query stucks my Script
Groups: php.general 
Request: Send a blank email to php-general+get-111488@lists.php.net to get a copy of this message
HELP!!! MSSQL2000 ,windows 2000, IIS, php4+. We have a problem running a quary with mssql. I try this: echo "Connect:".($c = mssql_connect('SERVER','sa','')).""; echo "selectDB:".mssql_select_DB('EMS_Config',$c).""; flush(); $rs = mssql_query('SELECT * FROM [Tester_Table];',$c) or die("query fails"); echo "query rs:".$rs.""; The mssql_connect succeeds and return a resource ID (#1). The mssql_select_db succeed too. (I can see it because of the flush ) But when the code gets to mssql_query, the page is stuck. It is waiting for the SQL to reply. The table is leagal, and there are only 3 records in it. If I give an sql sintax error or a bad table name, I get an immediate respond from the SQL server, with the correct error message. When I give a leagal select - it gets stuck, and the php engin even does not terminate execution, even when the page exceeds the time-limit for execution of a script-page. Any ideas?

« previous php.general (#111488) next »