ID: 41244
Updated by: [EMAIL PROTECTED]
Reported By: mallinger at tc dot edu
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: Windows 2003 Server
PHP Version: 5.2.1
New Comment:
MS SQL server does not allow new queries on the same connection as long
as there are results pending the clients actions. Either fetch all data
or release the result before sending new queries.
Another solution is to have multiple connections. mssql_connect()
supports an optional parameter to force the creation of a new connection
even if host, user and password is the same as for an existing
connection.
Previous Comments:
------------------------------------------------------------------------
[2007-04-30 17:58:34] mallinger at tc dot edu
Description:
------------
When executing multiple queries from a single mssql_query call, the
connection is lost and subsequent connections cannot be created. There
are similar problems documented for PHP4, but it seems that (a) this is
not documented for PHP5; and (b) the inability to create subsequent
connections is not documented. In particular, it seems the
mssql_select_db is what is failing in the second connection.
Reproduce code:
---------------
$conn = mssql_connect('host', 'user', 'pass');
mssql_select_db("db", $conn);
mssql_query("QUERY 1", $conn);
mssql_query("QUERY 2; QUERY 3; QUERY 4;", $conn);
// this will fail:
mssql_query("QUERY 5", $conn);
// this is ok
mssql_close($conn);
// everything below will fail too:
$conn2 = mssql_connect('host', 'user', 'pass');
mssql_select_db("db", $conn2);
mssql_query("QUERY 6", $conn2);
Expected result:
----------------
The queries should execute with no problems.
Actual result:
--------------
Everything after the multiple query mssql_query call ("QUERY 2; QUERY
3; QUERY 4;" will fail. New connections fail when trying to select a
database ("mssql_select_db() [function.mssql-select-db]: Unable to
select database:...") and the existing connection cannot be used anymore
("mssql_query() [function.mssql-query]: Query failed in...") .
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=41244&edit=1
