Failed to find or load the registered .Net Framework Data Provider

Tonight I was trying to setup and use the ASP.NET GridView with the MySql Connector to allow for easy editing of code table for a site I'm creating. The framework I'm going against for this project is the .Net Framework 4.0 (I downloaded the source code for the MySql connector and I compiled against 4.0 so I would have a native library that didn't have to also have 3.5 present).

Anyway, the above error is fixed by adding the following to the web.config:

<system.data>
<dbproviderfactories>
<remove invariant="MySql.Data.MySqlClient" />
<add name="MySql Data Provider" invariant="MySql.Data.MySqlClient"
        description=".Net Framework Data Provider for MySql"
        type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data" />
</dbproviderfactories>
</system.data>

For reference, the bones of the SqlDataSource in the ASP.Net markup looks something like this:

<asp:SqlDataSource ID="dsMySql" runat="server"
                        ConnectionString="<%$ ConnectionStrings:MySqlMain%>"
                        ProviderName="<%$ ConnectionStrings:MySqlMain.ProviderName%>"
                        SelectCommand=""
                        UpdateCommand=""
                        DeleteCommand=""
                        InsertCommand="">
</asp:SqlDataSource>

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.

Leave a comment