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

x
?
Solved

MSSQL:   Connection is busy with results for another hstmt

Posted on 2004-11-04
1
Medium Priority
?
349 Views
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
0
Comment
Question by:kako
1 Comment
 
LVL 11

Accepted Solution

by:
rdrunner earned 500 total points
ID: 12502401
Hello,

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
0

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