Attribute

TransactionMode (tm)

Purpose

Specifies how the driver handles manual transactions.

Valid Values

0 | 1 | 3

Behavior

If set to 0 (NoTransactions), the data source and the driver do not support transactions. Metadata indicates that the driver does not support transactions.

If set to 1 (Ignore), the data source does not support transactions and the driver always operates in auto-commit mode. Calls to set the driver to manual commit mode and to commit transactions are ignored. Calls to rollback a transaction cause the driver to throw an exception indicating that no transaction is started. Metadata indicates that the driver supports transactions and the ReadUncommitted transaction isolation level.

If set to 3 (Full), the driver passes explicit transaction control commands such as BEGIN TRANSACTION, COMMIT, and ROLLBACK to the service.

Default Value

3 (Full)