在 Visual Studio 2010 Professional 中找不到请求的 .Net Framework 数据提供程序 [英] Unable to find the requested .Net Framework Data Provider in Visual Studio 2010 Professional

问题描述

在 Visual Studio 2010 Professional 中尝试设置新数据源时，为什么会出现无法找到请求的 .Net Framework 数据提供程序"?

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 64 位 16gig 内存
• Visual Studio 2010 专业版
• SQL Server 2008(服务器 A，完全管理员权限)
• SQL Server 2008(服务器 B，完全管理员权限)

我已经启动了一个测试 ASP.NET 应用程序，当我尝试添加一个新的数据源时，我得到:

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

无法找到请求的 .Net Framework 数据提供程序.可能没有安装.

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 位于 WindowsMicrosoft.netFrameworkvXXXXConfig 中.根据安装的框架版本数量，您可以拥有大量配置文件，包括 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 WindowsMicrosoft.netFrameworkvXXXXConfig. 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 Professional 中找不到请求的 .Net Framework 数据提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！