note 24020 added to function.mssql-query
| From: | Osher at tapuz dot co dot il | 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