"Operation cannot be performed while executing asynchronously"

[LucieLastic]

We've started to get this error from a DLL I wrote. The DLL has very simple ADO components in it and it's used from HTB/Turbo Basic. The DLL allows HTB to connect to a database and run SQL statements.

The DLL is written in Delphi 7 and accesses SQL Server 2005. Nothing that I know of has changed and this HTB code was running fine last week.

The table it's accessing is a very big table and could it be a case that the last SQL command hasn't finished when the HTB code is trying to send another Insert statement (via the DLL)?

Could it be an option I need to change in the TADOConnection component?

Many thanks
Lou

 

[whosrdaddy]

do you have ExecuteOptions set to [eoAsyncExecute]?

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[LucieLastic]

I was looking for this property so I could set it, could you tell me where it is?

 

[whosrdaddy]

depends on what you use (TADOQuery, TADOStoredProc, TADOTable, ...)

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!