SQL not allowing me to connect after multiple inserts
| From: | BB | 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