To force the support of distributed transactions when connecting to two or more data sources, and one of them does not support transactions, set the following value:

 

FORCETRANSACTIONS = 1 

 

Default = 0.

 

Environments: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  FORCETRANSACTIONS

 

Unix Registry Setting: CONNX.FORCETRANSACTIONS