Kbase P142098: How to Turn on autocommit with MS SQL Server DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/02/2009 |
|
Status: Unverified
GOAL:
How to turn on autocommit with MS SQL server DataServer?
GOAL:
How does MS SQL server DataServer commit transactions?
FACT(s) (Environment):
Windows
MS SQL DataServer
FIX:
By default, MS SQL Server DataServer manages transactions behind the scene and commit transactions in batches, however, sometimes, application is required to commit transactions more frequently. Under such circumstances, consider following -Dsrv option.
Transaction Management: the AUTOCOMMIT option
To avoid using the MS SQL Server transaction manager, specify -Dsrv AUTOCOMMIT,1. This option exercises the OpenEdge client?s local before-image mechanism to manage transactions. This creates a transaction from each SQL statement that the DataServer issues. OpenEdge emulates the logical transaction on behalf of the application using the local before-image mechanism. This connection technique is useful in multi-database applications.