title: Why does opening a connection throw a distributed transactions error in MySQL? (.NET Connector)
body: <p>I'm opening a connection to a local MySQL server and on the <code>connection.Open()</code> method it throws this error:</p>
  
  <blockquote>
    <p>System.NotSupportedException: MySQL Connector/Net does not currently support distributed transactions.<br>
    at MySql.Data.MySqlClient.MySqlConnection.EnlistTransaction(Transaction> transaction)
    at MySql.Data.MySqlClient.MySqlConnection.Open()</p>
  </blockquote>
  
  <p>All I'm doing is this:</p>
  
  <pre><code>var connection = new MySql.Data.MySqlClient.MySqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString);
  connection.Open();
  </code></pre>
  
  <p>The connection string in the app.config is </p>
  
  <pre><code>&lt;add name="Connection" connectionString="server=localhost;user id=userid;Password=password;database=dbname" providerName="MySql.Data.MySqlClient" /&gt;    
  </code></pre>
  
  <p>I don't know why it's trying to enlist the transaction, I haven't specified any transactions &amp; I only have one MySQL server I'm connecting to</p>