The requested. NET Framework data provider was not found when accessing the MySQL database. may not be installed. "Solution

A system was recently developed to deploy on a test environment (Win7 environment) and tested, no problem was found, but after the system was deployed to win SERVER2008R2, some pages reported "the requested. NET Framework data provider could not be found." may not be installed. "Error, troubleshoot the server, the framework version on the server is installed from 2.0, 3.5, 4.0, and the developed system can be deployed normally when using a SQL Server database. The final decision is to change the database (from SQL Server to MySQL) caused by environmental problems or configuration problems, and finally by looking for data, Modified the Web. config node problem is resolved, the MySQL-related DLLs added to the Web. config can be, as follows:

1<system.data>2<DbProviderFactories>3<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.6.5.0, Culture=neutral, publickeytoken= C5687FC88969C44D"/>4</DbProviderFactories>5</system.data>

View Code

It contains the name, version, and PublicKeyToken information of the DLL, as long as it corresponds to the DLL you added.

The requested. NET Framework data provider was not found when accessing the MySQL database. may not be installed. "Solution