ID: 27204
User updated by: willy at vuboys dot nl
Reported By: willy at vuboys dot nl
-Status: Feedback
+Status: Open
Bug Type: MSSQL related
Operating System: Windows XP SP1
PHP Version: 4CVS-2004-02-10
New Comment:
Let me explain;
sp_help returns more the one resultset. In previous versions of PHP
(4.2.3 and earlier) this function worked perfectly without freeing the
result or browsing to all result sets. In this version suddenly all
queries after it fail.
Again uncommenting those two lines is a workaround. But surely the
connection to the database should not be lost after this query. It's
running a query and not fetching the result and then running a new
query. Surely in this case the connection should not be lost.
Therefore I feel it is a bug.
Previous Comments:
------------------------------------------------------------------------
[2004-02-12 10:37:43] [EMAIL PROTECTED]
I don't know mssql at all..but what might that 'sp_help' query
supposedly do? (some url pointing to a document explaining it is
enough..) It sounds like something you're not allowed/supposed to do
from a script..
------------------------------------------------------------------------
[2004-02-10 06:23:35] willy at vuboys dot nl
Description:
------------
After you run mssql_query("sp_help") all following queries fail. I am
using PHP4.3.4 running as ISAPI module in IIS5 on Windows XP. SQL
Server 2000, version 8.00.760.
When you uncomment both lines in the reproduce script:
while (mssql_next_result($result));
mssql_free_result($result);
the script does work.
Reproduce code:
---------------
if ( ! $connect_id = mssql_connect( $sql_host,$sql_user,$sql_pass ) )
{
die("Could not create a MSSQL connection, please check the SQL values
entered");
}
if ( ! mssql_select_db($sql_database, $connect_id) )
{
die("MSSQL could not locate a database called
'{$VARS['sql_database']}' please check the value entered for this");
}
$result = mssql_query("SELECT @@VERSION");
$row = mssql_fetch_row($result);
echo $row[0]."<br />";
$result = mssql_query("sp_help", $connect_id);
while ($table = mssql_fetch_array($result))
{
if (($table[2]=="user table") && (!($table[0]=="dtproperties"))) {
echo $table[2]." | ".$table[0]."<br />";
}
}
// while (mssql_next_result($result));
// mssql_free_result($result);
$result = mssql_query("SELECT @@VERSION");
$row = mssql_fetch_row($result);
echo $row[0]."<br />";
mssql_close($connect_id);
?>
Expected result:
----------------
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on
Windows NT 5.1 (Build 2600: Service Pack 1)
user table | table 1
...
user table | table n
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on
Windows NT 5.1 (Build 2600: Service Pack 1)
Actual result:
--------------
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on
Windows NT 5.1 (Build 2600: Service Pack 1)
user table | table 1
...
user table | table n
Warning: mssql_query(): Query failed in c:\inetpub\wwwroot\testsql.php
on line 33
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=27204&edit=1
