ID: 6861
Updated by: kalowsky
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
Assigned To: 

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 

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

header("Cache-Control: no-cache, invalidate");
header("Pragma: no-cache");
  if ( $type ) {
    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">

Transact-SQL Stored Procedure
------- BEGIN -------
CREATE PROCEDURE sp_textcopy (
  @dummy     varchar (30)
EXEC master..xp_cmdshell "dir H:\winnt\system32"
-------- END --------


ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to