Cannot create new connection because in manual or distributed transaction mode

By: Angel Martinez

Abstract: Work around this problem with the dbExpress MSSQL driver

Problem


When using the MSSQL dbExpress driver with a ClientDataSet and a Provider, keep getting the following error when calling ApplyUpdate:
Cannot create new connection because in manual or distributed transaction mode


Suggested Work Around:


Set "poFetchDetailsOnDemand" (for the Provider) to False. This is a known issue when it is set to True.


Server Response from: ETNASC03