Ending Explicit Transactions
In SQL, a transaction is completed by a COMMIT
or ROLLBACK
request.ODBC has methods that do one or the other, such as SQLEndTran
.Some programs are able to invoke SQLExecDirect
but cannot call SQLEndTran
.For those programs it is necessary to call an explicit
SQLExecDirect( hStmt, "COMMIT" )
to ensure that the interface will call
SQLEndTran( SQL_HANDLE_DBC, hConnection, SQL_COMMIT );
Note
|
If a transaction is initiated locally, the driver will execute |