Set Attributes to specify whether a connection object performs retaining commits or retaining aborts. The two behaviors are independent of each other. 

Attributes can contain one of the two TXactAttribute values (xaCommitRetaining and xaAbortRetaining), both values, or neither value.

ADOConnection1.Attributes := [xaCommitRetaining, xaAbortRetaining];

ADOConnection1->Attributes = TXactAttributes() << xaCommitRetaining << xaAbortRetaining;

Specifying Whether the Connection Automatically Initiates Transactions