Distributed Transaction problem.

[Brekko]

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]

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.