Transaction
Found in
Section
Description
Specifies whether database transactions are to be used.
This setting must be set to 0 if you are using a Microsoft SQL
Server database.
The purpose of the setting is to add stability in the database access process with the help of extended transaction management. (Invoices uses transactions even when the setting is 0, but in smaller chunks.) It works best with an Oracle database.
Important In older installations where the original
Eiglobal.ini file was kept during an upgrade, the
setting is not affected.
In older installations where the original Eiglobal.ini file was kept during an upgrade, the setting is not affected.
(In the Invoices 5-5 installation without any service pack, the default setting was 0, as intended.)
Valid values
- 1 (ok for Oracle)
- 0 (default – required for SQL Server)