The requested. Net Framework Data Provider could not be found. may not be installed.

The requested. Net Framework Data Provider could not be found. may not be installed.

Workaround:

Install Microsoft SQL Server Compact 4.0.

After you install Microsoft SQL Server Compact 4.0, the program runs fine.

The problem is because the program connects. SDF database error, so install Microsoft SQL Server Compact 4.0.

Microsoft SQL Server Compact 4.0 Chinese version:

http://www.microsoft.com/downloads/zh-cn/details.aspx?familyid=033cfb76-5382-44fb-bc7e-b3c8174832e2& Displaylang=zh-cn

After installation if not:

You cannot connect to SQL Server in Server Explorer in Visual Studio 2010, and the dialog box prompts " the requested. NET Framework Data Provider could not be found. may not be installed "

Workaround:

Open C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config, copy the content under the DbProviderFactories nodeReplaceC:\WINDOWS\Microsoft.NET\Framework\v4.0.30319the corresponding position in the \config\machine.config.

<DbProviderFactories>
<add name= "ODBC data Provider" invariant= "System.Data.Odbc" description= ". Net Framework Data Provider for Odbc" Ty Pe= "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 "Type=" 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,

The requested. Net Framework Data Provider could not be found. may not be installed.