Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


MSSQL:   Connection is busy with results for another hstmt

Posted on 2004-11-04
Medium Priority
Last Modified: 2006-11-17
I have run MSSQL server  on different 3 computer.
(just same data and log files)
client code is same too,
but one of the server return me error:
---Connection is busy with results for another hstmt ---

obviously problem is with database setting but I cant locate which one is guilty
please help
Question by:kako
1 Comment
LVL 11

Accepted Solution

rdrunner earned 500 total points
ID: 12502401

Most likely you are using a still open recordet. You expected only ONE row but the querry actually returned 2 rows and this causes your program to fail. Make sure you really only get one record here.

Another option can be that you return a rowcount for an operation where you dont return a record. Thiscan mess up your recordsets also. turn rowcount off in your stored procedure.

Hope this helps

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question