Board index » delphi » Hstmt error : Connection is busy

Quote

Hi every one,

Since few days we are facing error that connection is busy with result
set of another hstmt in our Delphi Application EXE. As far as i know if
we open two query at same time and those two query component uses the
same TDatabase component this error may occur. I am using same
Tdatabase component in the whole application. But in my problem, we
have different SQL database for different clients. EXE connects to
Database using ODBC DSN and BDE. On one database when i run EXE i get
this error. but if i change ODBC configuration and point DSN to new
database. Now this error is not comming. I need to find the reason for
that as this error is also occuring at our client end.

If any one has ever face such error... Please help me out


Thanks,
Divyesh
This has to do with BDE, or better, because using of server side cursor