OLE DB Property of Rowset and Command — «Preserve on Commit»
In the general case the rowset will not function after transaction commit.
Note that you cannot explicitly control an automatic transaction. Therefore, when an automatic transaction is used, it will be active until the complete release of rowset.
- Rowset property Preserve on Abort