title: Using ADO.NET MySQL Provider in MVC3 (Unable to find the requested .Net Framework Data Provider. It may not be installed.)
body: <p>Im trying to connect to a mysql database on my web server, but I keep getting:</p>
  
  <pre><code>Unable to find the requested .Net Framework Data Provider.  It may not be installed.
  </code></pre>
  
  <p>Im guessing that the ADO.NET connector is present because if I change my config to:</p>
  
  <pre><code>providerName="System.Data.SQLClient"
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
  </code></pre>
  
  <p>My provider config is:</p>
  
  <pre><code>    &lt;add name="MySQLMembershipProvider" type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.0.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer"
           enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false"
           autogenerateschema="true" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"
           applicationName="/" /&gt;
    &lt;/providers&gt;
  </code></pre>
  
  <p>My Connection string is:</p>
  
  <pre><code>&lt;add name="LocalMySqlServer"
       connectionString="Data Source=localhost;user id=web210-aaron;password=tester;database=web210-aaron;"
       providerName="System.Data.MySQLClient"/&gt;
  </code></pre>
  
  <p>Im pretty sure this is correct, especially as if I run it from my local machine (changing the host to the server IP) it runs perfecly! Could someone please confirm that this is a correct connection string.</p>