EnableTransactions

When this option is enabled (1), the connector simulates transactions for all connections, ensuring compatibility with applications that require transaction support. Simulated transactions are not executed.

This property applies to all connections that use the connector, so it is configured differently compared to properties that are set on a per-connection basis. You cannot set EnableTransactions in connection strings.

in Windows machines, you must set this property in one of the following registry keys:

  • For a 32-bit connector installed on a 64-bit machine: HKEY_LOCAL_MACHINE\SOFTWARE\Simba\Simba Salesforce ODBC Connector\Driver
  • Otherwise: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Simba\Simba Salesforce ODBC Connector\Driver

On non-Windows machines, you must set this property in the simba.salesforceodbc.ini file instead of the odbc.ini file.

Note:

For information about configuring the connector to only simulate transactions for specific connections, see SimulateTransactions. If the SimulateTransactions key is set, it takes precedence over the EnableTransactions setting.

Key Name Default Value Required

EnableTransactions

0

No