在Visual Studio 2010中缺少Server Explorer的右键单击菜单选项 [英] Missing Server Explorer right-click menu options in Visual Studio 2010

问题描述

我一直在高低寻找答案，却找不到任何答案.我已经在运行MS XP Pro的虚拟机上安装了VS 2010专业版.连接到数据库后，我可以在列表中看到所有表，存储过程和函数.但是，当我用鼠标右键单击其中的任何一个时，都会丢失用于创建/编辑/运行其中任何一个的选项.

I've searched high and low for the answer to this and can find nothing on it. I have installed VS 2010 pro edition on a virtual machine running MS XP Pro. After connecting to my database, I can see all the tables, stored procedures, and functions just fine in the list. However, when I rick-click on any of them, the options to create new/edit/run any of them are missing.

这不是我第一次设置VS2010.我有了新笔记本电脑，所以重新安装了所有内容.第一次设置时，我没有更改任何设置，这次没有设置.我每次都以相同的方式设置与数据库的连接，甚至在设置此安装时查看了我以前的连接设置.旧的安装程序具有所有右键单击选项，但没有.我已尝试转到Tools -> Import and Export Settings -> Reset all settings，并尝试将General Development Settings，Visual C# Development Settings和Web Development作为默认设置集合.这些都不起作用.

This is not the first time I've set up VS 2010. I got a new laptop so reinstalled everything. I changed no settings the first time I've set this up, and none this time. I set up the connection to the databases the same way each time, and even looked at my old connection settings while I set up this installation. The old installation had all of the right-click options, but this one does not. I have tried going to Tools -> Import and Export Settings -> Reset all settings and tried General Development Settings, Visual C# Development Settings, and Web Development as the default collection of settings. None of these worked.

我浏览了所有设置，但右键单击菜单没有发现任何问题.似乎数据库连接似乎是在只读"模式下打开的，但是似乎没有设置，所以我认为情况并非如此.如果有人知道以任何方式显示这些选项，我将不胜感激.预先感谢.

I've looked through the settings and found nothing for the right-click menu. It almost seems as if the database connection is open in a "read only" mode, but there doesn't seem to be a setting for that, so I don't think that is the case. If anyone knows of any way to get these options to show up, I would greatly appreciate the input. Thanks in advance.

推荐答案

为了解决这个问题，我更加尝试了这种连接.我最初选择Microsoft SQL Server作为数据源，而选择.NET Framework Data Provider for OLE DB作为数据提供程序.显然，数据提供者是错误的.选择.NET Framework Data Provider for SQL Server后，它起作用了，我可以看到所有的右键单击菜单选项.

Desperate to resolve this, I played around with the connection more. I had originally chosen Microsoft SQL Server as the data source, and .NET Framework Data Provider for OLE DB as the Data Provider. Evidently, the data provider was wrong. After choosing .NET Framework Data Provider for SQL Server, it worked and I could see all of my right-click menu options.

这篇关于在Visual Studio 2010中缺少Server Explorer的右键单击菜单选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！