Skip to content

Latest commit

 

History

History
16 lines (16 loc) · 719 Bytes

setting-the-commit-mode.md

File metadata and controls

16 lines (16 loc) · 719 Bytes
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Setting the Commit Mode
Setting the Commit Mode
David-Engel
davidengel
01/19/2017
sql
connectivity
conceptual
transactions [ODBC], commit modes
committing transactions [ODBC]
commit modes [ODBC]

Setting the Commit Mode

Applications specify the transaction mode with the SQL_ATTR_AUTOCOMMIT connection attribute. By default, ODBC transactions are in auto-commit mode (unless SQLSetConnectAttr and SQLSetConnectOption are not supported, which is unlikely). Switching from manual-commit mode to auto-commit mode automatically commits any open transaction on the connection.