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. |
|
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.
|