DEX3 SQL server transaction bug

[cgkls]

I have Embarcadero® RAD Studio XE3 Version 17.0.4770.56661 update 2 Delphi
Unidac 46d17 pro

SqlServer 2008R2.

MARS OFF
My program open a few Query and I need to start a transaction.
I have the following message :
EOLEBDError ‘Connection is busy with results for another command’


If I set MARS on I must close all query before start any transaction.

Only a few transaction in my program have this bug. If bug append in a context, it will happen all time.

[AndreyZ]

Such problem can occur if there are under-fetched datasets within the connection. No transactions can be started if there are under-fetched datasets within the connection. To avoid the problem, you should set the FetchAll specific option to True (FetchAll is True by default). Here is a code example:

Code: Select all

UniQuery.SpecificOptions.Values['FetchAll'] := 'True';

For more information, please refer to http://www.devart.com/sdac/docs/devart_ ... tchall.htm

[cgkls]

Thank you, this is the good solution.

[AndreyZ]

Feel free to contact us if you have any further questions about UniDAC.