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]