Error : Connection is busy with results for another hstmt

[StevenK]

We've been developing an in-house application using Delphi 5 against a SQL Server 7.0 database. This is constantly under development with functionality being increased.
We've recently adopted a problem whereby we are presented with the error 'Key violation. General SQL error. [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.'
This occurs when we open a TQuery (Delphi component) with SQL Syntax 'SELECT * FROM ....' where the table only has three fields and ten records.
We've established that the issue is not related to network traffic or packets as we have run the application locally on a machine with an install of SQL Server (no network connections).
Can anyone shed some light as to what we might have upset in the application development so that we can correct this ?
Thanks for any help in advance
Steve

 

[tlbroadbent]

Usually, this is caused by simultaneously executing a second query on the same connection that is already executing an asynchronous query. It can usually be solved by making sure you move to the last record in the first query before executing the 2nd query.

Search the Microsoft Knowledgebase for more info on this error. There are a number of articles about it. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.