DTC issue with WCF Transaction

[RitenGohil]

Hi, I am using WCF transaction and within the transaction scope calling the wcf services.

For e.g. In transaction scope, we are calling GetName method of service1 and then GetAddress method of service1. First method call i.e. GetName executes properly but while trying to execute the second method i.e. GetAddress, it is giving exception "The underlying provider failed on Open.Connection is already attached to distributed transaction."

- It is happening when hitting the methods of same service.
- Using devart dotconnect mysql version 8.4.583.0
- .Net Framework 4.0

[Shalex]

We have asked for the additional information by email.

[RitenGohil]

Hi, We have already given the test project and other required details for this issue. It is kind of blocker for our project. The same code works fine with SQL Client.

Please guide us how to resolve this issue.
Awaiting for your reply.

[Shalex]

Thank you for your test project. We have reproduced the "Connection is already attached to distributed transaction." issue and are investigating it. We will notify you about the result.

As a workaround, please set "Pooling=false;" in your connection string (verified, it works).

[Shalex]

The bug with enlisting connections to a distributed transaction is fixed in the newest (8.6.743) build of dotConnect for MySQL.