Devart Forums

Hi,
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 ?

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.