note 24020 added to function.mssql-query

From: Date: Sun, 04 Aug 2002 10:21:27 +0000
Subject: note 24020 added to function.mssql-query
Groups: php.notes 
Request: Send a blank email to php-notes+get-34259@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',''))."<br>"; echo "selectDB:".mssql_select_DB('EMS_Config',$c)."<br>"; flush(); $rs = mssql_query('SELECT * FROM [Tester_Table];',$c) or die("query fails<br>"); echo "query rs:".$rs."<br>"; 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? -- http://www.php.net/manual/en/function.mssql-query.php http://master.php.net/manage/user-notes.php?action=edit+24020 http://master.php.net/manage/user-notes.php?action=delete+24020 http://master.php.net/manage/user-notes.php?action=reject+24020

« previous php.notes (#34259) next »