错误175：指定的数据存储提供无法找到 [英] Error 175: The specified data store provider cannot be found

问题描述

我使用VS2010与的MySQL .NET连接器。我的项目是用来工作开始报告：

I'm using VS2010 with the MySQL .NET Connector. My project that used to work started reporting:

错误175：指定的数据存储提供无法找到，或者是无效的。

Error 175: The specified data store provider cannot be found, or is not valid.

我不知道为什么，虽然事情变得怪异经过MS推荐的修补程序，以VS。

I don't know why, though things got weird after a MS recommended hotfix to VS.

果然，如果我去测试ADO.NET实体数据模型添加到项目中，实体数据模型向导生成.edmx文件不显示数据提供者时，我选择从数据库生成。更糟糕的是，右击并试图在现有的.edmx文件做一个更新型号从数据库...发送到VS2010的对话框中死亡螺旋，只能用任务管理器终止。

Sure enough, if I go to add a test ADO.NET Entity Data Model to the project, the Entity Data Model Wizard that generates the .edmx file does not show the data provider when I select 'Generate from database'. Worse yet, right-clicking and attempting to do an 'Update Model from Database...' on an existing .edmx file sends VS2010 into a death spiral of dialog boxes that can only be terminated with Task Manager.

下面是我如何解决它：关闭VS2010。完全卸载的MySQL Connector。重新启动。完全安装的MySQL Connector。重新启动。重新启动VS2010。

Here's how I fix it: Shutdown VS2010. Uninstall the MySQL Connector completely. Reboot. Install the MySQL Connector completely. Reboot. Restart VS2010.

突然，我的数据提供者存在。我可以编译我的code。除了增加测试的.edmx文件。该向导会看到我的MySQL数据库，通过测试连接，并建立对象模型和我的关系表。我可以清洁/重建就像我想要的。

Suddenly, my data provider exists. I can compile my code. As well as add test .edmx files. The wizard sees my MySQL database, passes the test connection, and builds object models with my relational tables. I can clean/rebuild as much as I want.

所有的好，直到我运行应用程序。我的修复不沾。

All's good until I run the app. My "fix" doesn't stick.

在这一点上抛出一个异常，说明该连接对象返回null，如果我重新编译，没有code的变化，我再次得到错误175错误。车床，漂洗，重复。

At that point an exception is thrown stating that the connection object is returning null, and if I recompile with no code changes, I get the Error 175 error again. Lather, rinse, repeat.

一些<一href="http://stackoverflow.com/questions/434864/how-to-check-if-connection-string-is-valid">experiments根据关闭这个计算器回答，表明连接字符串是有效的，然后使用MySqlConnection对象，我可以访问数据库，并推出自己的工作查询在该状态

Some experiments based off of this StackOverflow answer, show that the Connection String is valid, and using the MySqlConnection object, I can access the database and roll my own working queries in this state.

这个问题似乎是，数据存储提供商以某种方式迷路或踩，这是影响通过EntityFrameworks做的事情的能力。

The problem seems to be that the data store provider is somehow getting lost or stepped on, and this is impacting the ability to do things through EntityFrameworks.

我正在寻找在何处寻找这些一些建议被存储，如果任何人有过类似的事情，因此如果有任何有用的建议或想法，你觉得我可能会尝试。 ＆NBSP;

I'm looking for some advice on where to look for these being stored, if anyone has run across something similar, and if there's any useful suggestions or ideas you think I might try.  

更新 - 虽然这珍闻并没有解决我的问题，这的确让VS2010更稳定：立即卸载.NET连接器后，我检查下控制面板的安装的程序，发现有一个较旧的安装了.NET连接器为好。我卸载了一个从控制面板，重新启动，而则的安装新的。 VS2010现在还记得数据库供应商与EntityFrameworks 工作。显然，我安装了一个新的MySQL Connector以为它会卸载旧的，相反，他们遍步对方。

UPDATE -- While this tidbit did not solve my problem, it did make VS2010 more stable: Immediately after uninstalling of the .NET Connector, I checked under Control Panel's installed programs and found there was an older .NET Connector installed as well. I uninstalled that one from the control panel, rebooted, and then installed the new one. VS2010 now remembers the database provider for working with EntityFrameworks. Apparently I installed a newer MySQL Connector thinking it would uninstall the old one, instead they step all over each other.

现在，我得到一个 System.ArgumentException 在 System.Data.Entity.dll 陈述略有不同消息：

Now I'm getting a System.ArgumentException inside System.Data.Entity.dll stating the slightly different message:

指定的存储提供不能在配置中找到，或者是无效的。   System.ArgumentException：无法找到所需的.NET Framework数据提供。   它可能没有安装。

The specified store provider cannot be found in the configuration, or is not valid. System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.

这发生在 System.Data.Common.DbProviderFactories.GetFactory（字符串providerInvariantName）方法。

修订注记的 - 上面的原因罢工奏的是，Visual Studio 2010最终也再次失去了设置。但是我能够从控制面板卸载.NET连接器并重新安装连接器，无需重新启动，然后再返回了我的数据提供者的环境中。问题的这部分感觉更像是一个比一个.NET连接器发出VS2010的bug。

REVISION NOTE -- The reason for the strike-outs above is that VS2010 eventually did lose the settings again. But I was able to uninstall the .Net Connector from the control panel and reinstall the connector again, without a reboot, and got my data provider back again in the environment. This part of the problem is feeling more like a VS2010 bug than a .NET Connector issue.

推荐答案

问题走了显著更新后 - 这似乎是一个环境/驱动程序的bug毕竟

The problem went away after significant updates -- it appeared it was an environment/driver bug after all.

这篇关于错误175：指定的数据存储提供无法找到的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！