OLEDB causes problems

Results 1 to 2 of 2

Thread: OLEDB causes problems

  1. #1
    Join Date
    Dec 1969

    Default OLEDB causes problems

    Hi,<BR><BR>I am having trouble with OLEDB and ASP. I run W2K and SQL Server. What I wanted to do is<BR>switch from ODBC to OLEDB. <BR>I open all my recordsets using stored procedures and <BR>command objects.<BR><BR>When I open 2 forward-only cursors, which are open at the same time, everything works fine,<BR>but as soon as I open the second one with with a parameter passed to the stored procedure,<BR>I get an error like this:<BR><BR>Microsoft OLE DB Provider for SQL Server error &#039;80004005&#039; <BR>Connection is busy with results for another command <BR>/oletest1.asp, line 28 <BR><BR>Can anyone help me with this?<BR><BR>TIA<BR>Thomas<BR><BR>

  2. #2
    Medieval Dude Guest

    Default RE: OLEDB causes problems

    Have you tried creating a second connection? I&#039;ve never run into this problem before, but I&#039;ve never tried to do a lot of things at once using one connection. If you are only using one connection, I would at least try a second connection to see if that&#039;s the issue.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts