MsSql Transaction support with SDAC

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 7
Joined: Sun 02 Mar 2014 21:04

MsSql Transaction support with SDAC

Post by RoniLev » Tue 31 May 2016 10:22

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>?

Devart Team
Posts: 2062
Joined: Wed 30 Jul 2014 07:16

Re: MsSql Transaction support with SDAC

Post by ViktorV » Tue 31 May 2016 12:56

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.

Post Reply