Skip to content

setting-the-commit-mode.md

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 Setting the Commit Mode
description Setting the Commit Mode
author David-Engel
ms.author davidengel
ms.date 01/19/2017
ms.service sql
ms.subservice connectivity
ms.topic conceptual
helpviewer_keywords
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.