Re: Connection is busy with results for another hstmt

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: oj (nospam_ojngo_at_home.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 15:48:09 -0800

Erland's lockinfo should help:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html

"Garey Taylor" <garey.taylor@gmail.com> wrote in message
news:97f2ba76.0501181154.343a1818@posting.google.com...
> Hi All,
>
> I've been getting this error:
> execute (SELECT sa_id,
> sa_title
> FROM SubjectArea
> WHERE j_id = 42
> AND active_ind = 1
> AND list_id = 1
> ORDER BY sa_title): [Microsoft][ODBC SQL Server
> Driver]Connection is busy with results for another hstmt
> (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
>
> I wish to find out what the other hstmt is that's causing the problem.
>
> Does anybody know where I can find this information? Does MSSQL log
> this information?
>
> Thanks,
>
> Garey

Relevant Pages

  • Connection is busy with results for another hstmt
    ... execute (SELECT sa_id, ... Driver]Connection is busy with results for another hstmt ... I wish to find out what the other hstmt is that's causing the problem. ... Garey ...
    (microsoft.public.sqlserver.programming)
  • Stored Procedure Resultsets?
    ... rc = SQLNumParams (*hstmt, &numParams); ... It seems like I have to close the cursor before I execute another call. ... Is there any way for the stored procedure to not return a resultset (if it ...
    (microsoft.public.sqlserver.programming)
  • Stored Procedure Resultset
    ... rc = SQLNumParams (*hstmt, &numParams); ... It seems like I have to close the cursor before I execute another call. ... Is there any way for the stored procedure to not return a resultset (if it ...
    (microsoft.public.sqlserver.odbc)
  • Re: I have problem about ODBC 3.x
    ... "Connection is busy with results for another hstmt"? ... Please do not cross-post. ... Frank Hickman ...
    (microsoft.public.vc.language)
  • error in update
    ... [ODBC SQL Server Driver]Connection is busy with results for ... another hstmt ... thx for your help ...
    (microsoft.public.vb.database)