AutoCommit

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.