Connection is busy with results for another hstmt -- dotnet odbc.net

dotnet odbc.net : Connection is busy with results for another hstmt

Paul Clement
5/10/2006 8:44:58 AM

[quoted text, click to view]

¤ Hello:
¤
¤ I'm using a connection in a web page to connect to SQL Server throught an
¤ ODBC driver, but from time to time and witthout using DataReaders (I return
¤ data in Datatables) I get an error like this:
¤
¤ [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
¤ another hstmt
¤
¤
¤
¤ Anyone can help me?
¤
¤ The connection is unique for each page I call.

Is this happening with a connection that is being reused in the page for each DataTable or a new
connection that is created each time?

Paul
~~~~

Juan
5/10/2006 1:01:30 PM

Hello:

I'm using a connection in a web page to connect to SQL Server throught an
ODBC driver, but from time to time and witthout using DataReaders (I return
data in Datatables) I get an error like this:

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another hstmt

Anyone can help me?

The connection is unique for each page I call.

Thanks

Juan
5/11/2006 12:01:16 PM

It's being reused in all the web page, I connect when it starts and close
when ends. I think the ADO.Net wrapper should support this.

Any idea?

Thanks

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> escribió en el
mensaje news:2dr362h0d8hlgv9jf3pguivibl04dd67fr@4ax.com...
[quoted text, click to view]

Paul Clement
5/15/2006 11:52:08 AM

[quoted text, click to view]

¤ It's being reused in all the web page, I connect when it starts and close
¤ when ends. I think the ADO.Net wrapper should support this.
¤

It's OK as along as you're not attempting to hook it up to multiple DataReaders.

Paul
~~~~

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet odbc.net

home · blog · groups

Questions? Comments? Contact the dn