MsSql Transaction support with SDAC

[RoniLev]

Hi There
I use Delphi XE2 with SDAC.
I want to use transaction to update 2 MsSql server tables.
I got this error on commit:
"MSDTC on server 'servername' is unavailable"

how do solve this problem programmatically from delphi>?
Roni

[ViktorV]

When working with a single database, you can not use distributed transactions. In this case, to work with transactions, you can use the following methods of the TMSConnection component: TMSConnection.StartTransaction, TMSConnection.Commit, TMSConnection.Rollback.