1, 22 Steps for recommended Practice
1. Place the MySql.Data.dll under the Bin directory, or install the Mysql-connector-net-6.0.0.msi
2.web.config Add the following nodes, the registration version number is consistent
<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, version=6.0.0.0, Culture=neutral, Publickeytoken=c5687fc88969c44d "/>
</DbProviderFactories>
</system.data>
3. Global configuration
In C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG, there is a field in Machine.config (XML file) that is <DbProviderFactories> There are entries written to the MySQL Data Provider,
If it is. NET 4.0, you need to manually change the Machine.config file. It's OK to copy the section below the v2.0.50727.
Add registration, <name= "SqlClient data Provider" > or <name= "MySQL data Provider" >
<system.data>
<DbProviderFactories>
<add name= "ODBC data Provider" invariant= "System.Data.Odbc" description= ". Net Framework Data Provider for Odbc" type= " System.Data.Odbc.OdbcFactory, System.Data, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089 "/>
<add name= "OLE DB data Provider" invariant= "System.Data.OleDb" description= ". Net Framework Data Provider for OLE DB" Typ E= "System.Data.OleDb.OleDbFactory, System.Data, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089" />
<add name= "OracleClient data Provider" invariant= "System.Data.OracleClient" description= ". Net Framework Data Provider for Oracle "type=" System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, version=2.0.0.0, Culture=neutral, publickeytoken=b77a5c561934e089 "/>
<add name= "SqlClient data Provider" invariant= "System.Data.SqlClient" description= ". Net Framework Data Provider for SQL Server "Type=" System.Data.SqlClient.SqlClientFactory, System.Data, version=2.0.0.0, Culture=neutral, publickeytoken=b77a5c561934e089 "/>
<add name= "SQL Server CE data Provider" invariant= "Microsoft.SqlServerCe.Client" description= ". NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition "Type=" Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, version=9.0.242.0, culture=neutral, publickeytoken=89845dcd8080cc91 "/>
<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.0.0.0, Culture=neutral, Publickeytoken=c5687fc88969c44d "/>
<add name= "SqlClient data Provider" invariant= "System.Data.SqlClient" description= ". Net Framework Data Provider for SQL Server "Type=" System.Data.SqlClient.SqlClientFactory, System.Data, version=2.0.0.0, Culture=neutral, publickeytoken=b77a5c561934e089 "/>
</DbProviderFactories>
</system.data>
The requested. Net Framework Data Provider could not be found. may not be installed