Unable to find the requested .Net Framework Data Provider. It may not be installed.

Hi All,

I am fairly new. When I publish my site. I receive this error for the one page that connects with the Winhost mysql server. Everything is fine when I run the website on local machine connecting to Winhost mysql dB:

[ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.]
System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) +1425695
System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactory() +67
System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactorySecure() +22
System.Web.UI.WebControls.SqlDataSource.CreateConnection(String connectionString) +11
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +113
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +101
System.Web.UI.WebControls.ListControl.PerformSelect() +34
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +30
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +105
System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +23
System.Web.UI.Control.PreRenderRecursiveInternal() +83
System.Web.UI.Control.PreRenderRecursiveInternal() +168
System.Web.UI.Control.PreRenderRecursiveInternal() +168
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +974

Here is the web.config:
<configuration>
<connectionStrings>
<clear/>
<remove name="ConnectName1"/>
<add name="ConnectName1" connectionString="server=Winhostprovided;User Id=****;database=WinhostProvided;password=*****;Persist Security Info=True"
providerName="MySql.Data.MySqlClient"/>
</connectionStrings>

<system.web>
<compilation debug="false" targetFramework="4.0">
<assemblies>
</assemblies>
</system.web>
</configuration>

 

Closed...

I added the trust level setting... It only took 6 hours to fix the issue