.net mysql 分布式事务处理,为什么打开连接MySQL中抛出一个分布式事务错误？ （.NET连接器）...

I'm opening a connection to a local MySQL server and on the connection.Open() method it throws this error:

System.NotSupportedException: MySQL Connector/Net does not currently support distributed transactions.

at MySql.Data.MySqlClient.MySqlConnection.EnlistTransaction(Transaction> transaction)

at MySql.Data.MySqlClient.MySqlConnection.Open()

All I'm doing is this:

var connection = new MySql.Data.MySqlClient.MySqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString);

connection.Open();

The connection string in the app.config is

I don't know why it's trying to enlist the transaction, I haven't specified any transactions & I only have one MySQL server I'm connecting to

解决方案

Try adding Enlist=false to your connection string:

EDIT: from the MySQL Connector/.NET documentation, if you set AutoEnlist=false in the connection string it should work.

It appears that certain versions of ADO.NET can default to automatically enlisting a connection into an existing transaction. See http://msdn.microsoft.com/en-us/library/ms254973.aspx for more detail, but I expect somehow somewhere ADO is confused into thinking that there's an existing transaction going on to some other db.