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

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
pgawli
Posts: 4
Joined: Fri 02 Mar 2007 11:49

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

Post by pgawli » Tue 07 Oct 2008 09:55

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
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Tue 14 Oct 2008 08:08

Please specify the version of SDAC you are using.

pgawli
Posts: 4
Joined: Fri 02 Mar 2007 11:49

Post by pgawli » Tue 14 Oct 2008 08:29

SDAC version 4.30.0.13

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Wed 15 Oct 2008 10:55

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
Posts: 15
Joined: Sun 15 Nov 2015 20:26

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

Post by Atys » Wed 08 Jun 2016 11:47

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
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

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

Post by ViktorV » Wed 08 Jun 2016 12:42

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.

Post Reply