SOLVED: MySQL Provider with Entity Framework Problem

rkotecha's Avatar

rkotecha

25 Feb, 2012 11:40 AM

Have to be brief here, but if you're getting exceptions like:
ArgumentException: The specified store provider cannot be found in the configuration, or is not valid.
ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.

You have to do the following:

  1. Ensure MySQL.Data.dll, MySQL.Web.dll, MySQL.Data.Entity.dll, and System.Data.Entity.dll are all being copied local (right click on assembly and ensure Copy Local is set to true)
    I also added the following locally as I tried to debug this problem but it was probably unnecessary
    System.Data.dll [probably optional]
    System.Data.Entity.Design [probably optional]

  2. And here's the step you wont read about in many places on google or on AppHarbor!
    Add the following to your web.config file:

      <system.data>
          <DbProviderFactories>
            <clear />
            <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
            description=".Net Framework Data Provider for MySQL"
            type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, 
            Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
          </DbProviderFactories>
        </system.data>
    
  1. Support Staff 1 Posted by friism on 25 Feb, 2012 06:16 PM

    friism's Avatar

    Awesome, thanks for sharing!

    Michael

  2. 2 Posted by Thong on 18 Sep, 2012 01:33 AM

    Thong's Avatar

    Thanks, This helps me alot after hours in Google :(. You have done it.

  3. friism closed this discussion on 18 Sep, 2012 01:34 AM.

Discussions are closed to public comments.
If you need help with AppHarbor please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac