Start Transaction

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

Start Transaction

Post by b_yaghobi » Fri 28 Apr 2006 09:49

My project have a Ont TMSConnection and many TMSTable and Active of all tables is True.
when i want to start transaction riase error "Cannot create new transaction
because capacity was exceeded."

can u help me ?

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 28 Apr 2006 13:28

Please check value of TCustomMSDataSet.FetchAll property.
When setting TCustomMSDataSet.FetchAll = False you should keep in mind that execution of such queries blocks current session. In order to avoid blocking OLE DB creates additional session. Each additional session runs outside of the transaction context. For more information please see restrictions of using FetchAll = False mode in SDAC help.

Post Reply