Post reply

problem in using stored procedure

  • March 11, 2010 at 6:51 am

    #230760

    i have developed a programm with qt;

    i use stored procedure widly;

    i found out when i use anything other than DDL command (even declare statement)

    ,i would cath a problem in my application. all my command would return this sql error after that :

    [cenetr]connection is busy with results for another hstmt ...[/center]

    i did n't know why it is.

  • March 11, 2010 at 7:37 am

    #1132042

    I think you need to run this through a spell checker since I'm not completely sure what you mean here.

    Can you run your stored procedures through SSMS? I'm not familiar with qt, what is that?

  • March 12, 2010 at 10:25 pm

    #1133129

    Hello .

    Thanks for your reply.

    yes . it has been run successfully in MSSM.

    Qt is an extended library on c++.

    I test like that program on delphi.

    when i set CurtorType property of AdoDataSet to clUseClient it work successfully (which means use client cursor for catching all return record in client side)

    but when i set CursorType property of AdoDataSet to clUseServer it failed like my qt to some extend(which means use server side cursor).

    I looked at profiler my qt program and I noted that qt uses server side cursor .

    I am almost sure my problem is the use of server side cursor but I don't know why!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply