In auto-commit mode, every SQL statement is a complete transaction, which is automatically committed. In manual-commit mode, a transaction consists of one or more statements. In manual-commit mode, when an application submits a SQL statement and no transaction is open, the driver implicitly begins a transaction. The transaction remains open until the application commits or rolls back the transaction with EDSTransact. If a driver supports EDSSetConnectOption, the default transaction mode is auto-commit, otherwise, it is manual-commit.

Applications should not use COMMIT or ROLLBACK statements to commit or roll back transactions. The result of a COMMIT or ROLLBACK statement depends on the driver and its associated data source.