Connection is busy with results for another command.

[uniguibbs]

i  put a Tconnection  on UniMainModule ,

 

all the other TDataSet   link  to the Tconnection.

 

when i save  a TDataSet to database, 

 

a exception raise  : "Connection is busy with results for another command."

 

what's going on?

 

 

 

 

 

 

[uniguibbs]

i put a unitimer on mainmodule .

timer run per 10 seconds  to  update a record .

 

may be it's the error reason

[mhmda]

which database you use?

[uniguibbs]

sql server2008

[Darth Florus]

I experiment this kind of problem with SQL Server because of dataaware.

 

My solutions is to use StoredProcedure to manipulate data.

 

They are so many ways to do that. Just pick one.

[uniguibbs]

i  use StoredProcedure. exception still exists.

all dataset use one Tconnecton;

may be timer execute in one thread.

 

may be timer cause the exception

 

[Farshad Mohajeri]

UniTimer only works when put on a TUniForm or a TuniFrame.

[Darth Florus]

If You use ADO to stablish the connection there are Asynconous update mode avaliable you cant use it as a workarround of a Timer.

 

Or just simply use ADO, work very well with SQLServer.

 

But still mandatory to not use DataAware framework to update data, only to show data on a grid. This is bassed on my experience of use Delphi with SQLServer.

 

Best Regards