Specifies whether the access service or the client application manages commit and rollback statements.
TransactionMode=[short | long]
short
long specifies the access service to give commitment control to the client application.
short specifies the access service to issue a commit or a rollback after each request.
The access service holds open the connection to the data source until the client application issues a commit or rollback, or until the ClientIdleTimeout value is exceeded.
If ClientIdleTimeout is exceeded, the transaction rolls back.
