AutoCommit (database connections) Purpose Specifies whether to use autocommit or manual-commit mode. Syntax DBConnection.AutoCommit [= Constant] Constant Possible values: SQL_AUTOCOMMIT_OFF The connection uses manual-commit mode. The application must explicitly commit or roll back a transaction. SQL_AUTOCOMMIT_ON The driver uses autocommit mode. Each command is committed immediately after it is executed. SQL_AUTOCOMMIT_DEFAULT Autocommit On. If no value for Constant is assigned, the default depends on the settings in your ODBC setup. Changing from manual-commit mode to autocommit mode commits any open transactions on the connection.