Distributed Transaction problem.

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Brekko
Posts: 1
Joined: Fri 26 Sep 2008 09:02
Contact:

Distributed Transaction problem.

Post by Brekko » Tue 30 Sep 2008 09:48

Hi, I'm a registered user of VCL components of SDAC for sql server.
I'm trying to do a distributed transaction using 2 different connections targeting the same sql server with 2 different databases.
I added my 2 connections to my TMSTransaction object and then started the transaction with StartTransaction method. Debugging the instruction I see StartTransaction method execution is very long (about 15 seconds).
After that I expect all query executed for my 2 connections are committed only after the commit method, but I can see new/updated records on my table with Microsoft SQL Server Management Studio also before committing my distributed transaction...

Transaction properties:
DefaultCloseAction = taCommit
IsolationLevel = ilReadCommitted

SDACTransaction.AddConnection(SDACConnectionArchive);
SDACTransaction.AddConnection(SDACConnectionMiddle);
My 2 connections are already opened when added to the transaction.

Anybody experienced something similar?
Must SQL server be configured to support distributed transaction?
Please help.
Thanks a lot.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 02 Oct 2008 09:34

I could not reproduce the problem.
When you use Distributed Transaction with IsolationLevel equal to ilReadCommitted, you can't read changed records until the Commit method is be executed.
Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Post Reply