Connection is busy with results for another hstmt

[cpope]

I am using IIS 4 with SQL Server 7 and am using many stored procedures to improve asp performance, but I am coming up with the spontaneous error:
"Connection is busy with results for another hstmt"
Has anyone ever had this error, if so is there a clean work around to this problem??? Please respond This is a very crucial part of my application! [sig][/sig]

 

[cpope]

Please respond to this post, it is very important, thanx [sig][/sig]

 

[NickBulka]

Here's a hint: whenever you get an error message that you need help with, go to search.microsoft.com, type in the exact error message, click "exact string", and submit the search.

Your error messages came up with 16 hits. give it a try.

And by the way, adding a response to read the original message will not get a quicker reply. [sig]<p>nick bulka<br><a href=mailto: > </a><br><a href=

http://www.bulka.com>

</a><br>Get your technical books at Bulka's Books<br>

http://www.vstorebooks.com/bulkasbooks

[/sig]

 

[cpope]

I did that already, it didn't come up with anything relevant to ASP development. I was wondering if anyone had already encountered this problem and had a work through using ASP. They say to use a recordset property &quot;StillExecting&quot; which is not a property in the ASP recordset. Has anyone encountered this problem with ASP?? [sig][/sig]