ID: 6861
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
Assigned To:
Comments:
is this still valid in the current releases?
Previous Comments:
---------------------------------------------------------------------------
[2000-09-23 08:41:55] [EMAIL PROTECTED]
I get the following ODBC Error:
"Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Connection is busy with
results for another hstmt, SQL state S1000 in SQLExecDirect in
Sample Source"
but only if the print statement
before the odbc_exec() calling the stored procedure sp_textcopy is there or if I
assign its result to a variable
i.e. $qryid=odbc_exec("sp_textcopy....") (See source below)
The message also appears erratically in another script of mine where i call a
preg_replace() and ONLY if I assign the result of the preg_replace to a variable (it
can be a dummy variable and have nothing to do with the rest of the script). Moreover,
it only happens with preg_replace() and not with preg_match(). The error also
disappears(!) if i do an ODD number of strlen($submission) before the odbc_exec() or
if i remove the $submission variable from the odbc_exec() string. Also, the stored
procedure seems to need to have an EXEC statement before the error will show up and
should have a lot of variables passed to it.
In the script below, removing the first <input> tag will also cause the error to
disappear.
All in all nothing seems to make sense, this sort of bug looks suspiciously like a
memory leak to me.
My ODBC driver is SQL Server 3.70.08.20
<?php
header("Cache-Control: no-cache, invalidate");
header("Pragma: no-cache");
?>
<html>
<body>
<?php
if ( $type ) {
$link=odbc_connect("HEECHEE-ODBC","webpage","");
odbc_exec($link,"use sampledb");
odbc_exec($link,"insert into table1 (row2)
values ('dummy')");
$qryid=odbc_exec($link,"sp_textcopy @srvname
= 'webpage'");
$qryid=odbc_exec($link,"select * from table1");
print odbc_exec($link,"sp_textcopy @srvname = ''");
}
?>
<form method=POST action="test.php">
<input type="text" name="type" value="article">
<input type="submit" value="Upload">
</form>
</body>
</html>
Transact-SQL Stored Procedure
------- BEGIN -------
CREATE PROCEDURE sp_textcopy (
@dummy varchar (30)
)
AS
EXEC master..xp_cmdshell "dir H:\winnt\system32"
-------- END --------
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=6861&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
