MSSQL:   Connection is busy with results for another hstmt

Posted on 2004-11-04
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


    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

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how the fundamental information of how to create a table.

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now