无法找到在Visual Studio 2010专业所要求的.NET Framework数据提供 [英] Unable to find the requested .Net Framework Data Provider in Visual Studio 2010 Professional

问题描述

为什么会出现无法找到所需的.NET Framework数据提供试图安装时，在Visual Studio 2010中一个新的数据源专业？

Why am I getting "Unable to find the requested .Net Framework Data Provider" when trying to setup a new datasource in Visual Studio 2010 Professional?

我的统计信息：

Windows 7 64bit 16gig RAM
Visual Studio 2010 Professional
SQL Server 2008  (server A, full admin rights)
SQL Server 2008  (server B, full admin rights)

我已经开始了一个测试ASP.NET应用程序，当我尝试添加一个新的数据源，我得到：

I have started a test ASP.NET application and when I try to add a new data source, I get:

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

我有.NET 4中安装。

I have .NET 4 installed.

当我建立连接，然后单击测试连接它测试成功。 SQL Server Management Studio中连接就好了，我已经验证凭据上的一切。

When I build the connection and click "Test Connection" it tests successful. SQL Server Management Studio connects just fine and I have verified the credentials on everything.

推荐答案

我已经看到了其在machine.config文件附加，自终止节点的人报告。删除它解决了他们的问题。 machine.config中发现的 \的Windows \ Microsoft.net \框架\ vXXXX \配置。如何根据该框架的许多版本安装，包括32位和64位变种你可以有多种配置文件。

I have seen reports of people having and additional, self terminating node in the machine.config file. Removing it resolved their issue. machine.config is found in \Windows\Microsoft.net\Framework\vXXXX\Config. You could have a multitude of config files based on how many versions of the framework are installed, including 32 and 64 bit variants.

<system.data>
    <DbProviderFactories>
        <add name="Odbc Data Provider" invariant="System.Data.Odbc" ... />
        <add name="OleDb Data Provider" invariant="System.Data.OleDb" ... />
        <add name="OracleClient Data Provider" invariant="System.Data ... />
        <add name="SqlClient Data Provider" invariant="System.Data ... />
        <add name="IBM DB2 for i .NET Provider" invariant="IBM.Data ... />
        <add name="Microsoft SQL Server Compact Data Provider" ... />     
    </DbProviderFactories>

    <DbProviderFactories/>  //remove this one!
</system.data>

这篇关于无法找到在Visual Studio 2010专业所要求的.NET Framework数据提供的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！