New transaction is not allowed because there are other ...

[pgawli]

Before transaction start I checked InTransaction property (false),
then I received error message: "New transaction is not allowed because there are other threads running in the session."

I have no idea what's causing this error. (Application working more then one year without problems).

I need suggestions

Regards. Piotr

[Challenger]

Please specify the version of SDAC you are using.

[pgawli]

SDAC version 4.30.0.13

[Challenger]

The similar problem is discussed here http://devart.com/forums/viewtopic.php?t=13001. SQL Server raises this error when you have underfetched datasets on transaction start.

[Atys]

I know this thread is as old as the captain but since this is the first hit on google with devart and the
mentioned error message, i wanted to tell that in my case was an abandoned "UniDirectional=True" the
reason, after updating from BDE Querys.

[ViktorV]

When you set the UniDirectional property to True, the FetchAll property is set to False. Using the FetchAll mode has some limitations. You can find detailed information about it in the "TCustomMSDataSet.FetchAll Property" topic of SDAC help: https://www.devart.com/sdac/docs/?devar ... tchall.htm.