Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
321 08/08/12 06:40:51 : Query : select MemberCount from tbl_guild where serial = 6
322 08/08/12 06:40:51 : SqlState:HY000, NativeError:0  Msg:[Microsoft][ODBC SQL Server  Driver]Connection is busy with results for another hstmt 
323 08/08/12 06:40:51 : SQLExecDirect Returns : SQL_ERROR

Running on 2008 R2 on a win 2008 server.

The server software is closed source so i cannot edit it - and i have tried clean DB-s + clean server software that uses the DB.

The problem is still only related to one table, no other tables are logged with that error.

I cannot use native client, since its incompatible with the software.

How could the connection be busy for just one specific table and not the rest?.

share|improve this question
not a single idea about that=? – Agony Aug 9 '12 at 11:47

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.