SQL not allowing me to connect after multiple inserts

From: Date: Wed, 17 Oct 2001 10:40:31 +0000
Subject: SQL not allowing me to connect after multiple inserts
Groups: php.general 
Request: Send a blank email to php-general+get-71321@lists.php.net to get a copy of this message
I am running an IIS 5, php as an ISAPI layer and MSSQL 2k When I try to insert more than one row into a table in one statement SQL cannot reconnect to the SQL server for the remainder of the page. I have not found a solution or any other case like this, here is my code: <? $query = "USE Test\n"; $query .= "Insert into test (text) values ('query1');\n"; $query .= "Insert into test (text) values ('query2');\n"; $query_con = mssql_connect("localhost", "", ""); echo "<pre>$query</pre>"; if (mssql_query($query)) { echo "success"; } echo "<hr>re-select table: Test<br>"; mssql_select_db("Test"); ?> thanks in advance

« previous php.general (#71321) next »