问题：
在 Visual Studio 2010 Professional 中，我选择“服务器资源管理器”，然后右键单击“数据连接”以选择“添加连接”。然后我得到这个错误：
发生意外错误
.NET Framework 数据提供程序
微软 SQL Server Compact 3.5。
请联系提供商供应商
解决这个问题。
我的环境：
- Windows 7 SP1
- Visual Studio 2010 Professional（试用版）
- SQL Server 2008 R2 Express
我已经尝试过
- 安装 Visual Web Developer Express（出现同样的问题）
- 重新安装VS 2010 Professional
- 重装Sql Server 2008 R2 Express
- Tools =>导入导出设置=>重置所有设置
- 运行：Devenv.exe /ResetSkipPkgs
注释
也许注册表在某种程度上被搞乱了。
一篇文章：
http://social.msdn.microsoft .com/Forums/en/vstsstart/thread/b6f7fc36-5a34-4166-9e75-7ac39993182b
说我应该修改注册表
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\DataProviders
但我什至在 9.0（或 10.0）文件夹中没有名为 DataProviders 的文件夹。所以也许这是一个问题。
感谢您的帮助！
The problem:
In Visual Studio 2010 Professional I choose Server Explorer and right-click on Data Connections to choose "Add Connection". Then I get this error:
An unexpected error occurred in the
.NET Framework Data Provider for
Microsoft SQL Server Compact 3.5.
Please contact the provider vendor to
resolve this problem.
My enviroment:
- Windows 7 SP1
- Visual Studio 2010 Professional (trial version)
- SQL Server 2008 R2 Express
I've tried
- Installing Visual Web Developer Express (gives the same problem)
- Reinstall of VS 2010 Professional
- Reinstall of Sql Server 2008 R2 Express
- Tools => Import and Export Setting => Reset all Settings
- Run: Devenv.exe /ResetSkipPkgs
Comments
Maybe the registry is messed up in some way.
One post:
http://social.msdn.microsoft.com/Forums/en/vstsstart/thread/b6f7fc36-5a34-4166-9e75-7ac39993182b
says that I should modify the registry at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\DataProviders
But I don't even have a folder named DataProviders in the 9.0 (or 10.0) folder. So maybe that's a problem.
Thanks for any help!
发布评论
评论（2）
我开始“添加和删除程序”并删除所有名为“Visual Studio”的内容。然后我重新安装了 Visual Studio 2010 Professional。现在可以了！
I started "add and remove programs" and removed everything that was named something about "Visual Studio". Then I reinstalled Visual Studio 2010 Professional. And now it works!
我必须执行相同的操作并使用 VS 2010 卸载实用程序删除所有内容，然后重新安装所有内容。这是由 ODP for .Net 引起的，它没有正确安装，我无法连接到数据源，基本上意味着我无法编辑数据集文件！
I had to do the same and use the VS 2010 uninstall utility to remove everything, then reinstall it all. This was caused by ODP for .Net which didn't install properly and I could not connect to data sources and basically meant I could not edit the dataset file!