我无法在VS2010中为SQL Server Express创建数据库图表

时间:2021-08-24 00:43:24

For some reason, when I click Add Diagram in Server Explorer I am left with an empty tab for designing diagrams. However, there is no dialog box which usually asks what tables to add. The dropdown menu at the top called Diagrams also has all the buttons inactive.

出于某种原因,当我在服务器资源管理器中单击添加图表时,我留下了一个用于设计图表的空白选项卡。但是,没有对话框通常会询问要添加的表。顶部的下拉菜单名为Diagrams,所有按钮都处于非活动状态。

What could be the reason?

可能是什么原因?

I have my SQL Server Express running (checked in SQL Server Configuration Manager). Version - 10.1.

我运行了SQL Server Express(在SQL Server配置管理器中检查)。版本 - 10.1。

3 个解决方案

#1


2  

I switched to Visual Studio 2012 and I can build diagrams there. VS2010 on the same machine still has problems. VS2010 on my other computer - no problems. Still don't know what could be the issue.

我切换到Visual Studio 2012,我可以在那里构建图表。 VS2010在同一台机器上仍有问题。 VS2010在我的另一台电脑上 - 没问题。仍然不知道可能是什么问题。

#2


1  

After running into this problem in Visual Studio 2010, I switched to using SQL Server Management, but got the same problem. After doing some searching, I found two articles that were able to fix this for me. The discussion here: http://social.msdn.microsoft.com/Forums/en-US/d65c71f5-3887-4f2a-bbd3-e799a4ac6fdc/visual-studio-database-tools-error?forum=vstsdb

在Visual Studio 2010中遇到此问题后,我切换到使用SQL Server管理,但遇到了同样的问题。经过一番搜索后,我找到了两篇能够解决这个问题的文章。这里的讨论:http://social.msdn.microsoft.com/Forums/en-US/d65c71f5-3887-4f2a-bbd3-e799a4ac6fdc/visual-studio-database-tools-error?forum=vstsdb

has information that installing a newer beta version installs the visual database tools for 2012, but when uninstalling does not set it back to the older version. There were two locations for files that had to be replaced. The directory and file name of the DLL (on an X64 machine) is: C:\Program Files (x86)\Common Files\microsoft shared\Visual Database Tools\dsref80.dll There is a link to the dll in the posting.

有信息表明安装较新的beta版本会安装2012年的可视化数据库工具,但卸载时不会将其设置为旧版本。必须替换的文件有两个位置。 DLL(在X64计算机上)的目录和文件名是:C:\ Program Files(x86)\ Common Files \ microsoft shared \ Visual Database Tools \ dsref80.dll在发布中有一个指向dll的链接。

There was also a second folder some people had to replace, which was also referenced at this link: http://harshgupta71.blogspot.in/2013/02/the-specified-module-could-not-be-found.html The directory and file name of the DLL (on an X64 machine) is: C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8 There was a download to the replacement files as well.

还有一些人必须替换的第二个文件夹,也在这个链接中引用:http://harshgupta71.blogspot.in/2013/02/the-specified-module-could-not-be-found.html DLL的目录和文件名(在X64机器上)是:C:\ Program Files(x86)\ Common Files \ microsoft shared \ MSDesigners8也有替换文件的下载。

The other option instead of downloading these files is to rename the files/folders and then do a repair/reinstallation.

另一个选项而不是下载这些文件是重命名文件/文件夹,然后进行修复/重新安装。

#3


0  

I think that installing/re-installing the SQL Server Data Tools extension for VS 2010 should fix this problem.

我认为安装/重新安装VS 2010的SQL Server数据工具扩展应该可以解决这个问题。

You can download it here:

你可以在这里下载:

http://visualstudiogallery.msdn.microsoft.com/9b0228c6-15d1-44de-9279-66dde12bf861

http://visualstudiogallery.msdn.microsoft.com/9b0228c6-15d1-44de-9279-66dde12bf861

#1


2  

I switched to Visual Studio 2012 and I can build diagrams there. VS2010 on the same machine still has problems. VS2010 on my other computer - no problems. Still don't know what could be the issue.

我切换到Visual Studio 2012,我可以在那里构建图表。 VS2010在同一台机器上仍有问题。 VS2010在我的另一台电脑上 - 没问题。仍然不知道可能是什么问题。

#2


1  

After running into this problem in Visual Studio 2010, I switched to using SQL Server Management, but got the same problem. After doing some searching, I found two articles that were able to fix this for me. The discussion here: http://social.msdn.microsoft.com/Forums/en-US/d65c71f5-3887-4f2a-bbd3-e799a4ac6fdc/visual-studio-database-tools-error?forum=vstsdb

在Visual Studio 2010中遇到此问题后,我切换到使用SQL Server管理,但遇到了同样的问题。经过一番搜索后,我找到了两篇能够解决这个问题的文章。这里的讨论:http://social.msdn.microsoft.com/Forums/en-US/d65c71f5-3887-4f2a-bbd3-e799a4ac6fdc/visual-studio-database-tools-error?forum=vstsdb

has information that installing a newer beta version installs the visual database tools for 2012, but when uninstalling does not set it back to the older version. There were two locations for files that had to be replaced. The directory and file name of the DLL (on an X64 machine) is: C:\Program Files (x86)\Common Files\microsoft shared\Visual Database Tools\dsref80.dll There is a link to the dll in the posting.

有信息表明安装较新的beta版本会安装2012年的可视化数据库工具,但卸载时不会将其设置为旧版本。必须替换的文件有两个位置。 DLL(在X64计算机上)的目录和文件名是:C:\ Program Files(x86)\ Common Files \ microsoft shared \ Visual Database Tools \ dsref80.dll在发布中有一个指向dll的链接。

There was also a second folder some people had to replace, which was also referenced at this link: http://harshgupta71.blogspot.in/2013/02/the-specified-module-could-not-be-found.html The directory and file name of the DLL (on an X64 machine) is: C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8 There was a download to the replacement files as well.

还有一些人必须替换的第二个文件夹,也在这个链接中引用:http://harshgupta71.blogspot.in/2013/02/the-specified-module-could-not-be-found.html DLL的目录和文件名(在X64机器上)是:C:\ Program Files(x86)\ Common Files \ microsoft shared \ MSDesigners8也有替换文件的下载。

The other option instead of downloading these files is to rename the files/folders and then do a repair/reinstallation.

另一个选项而不是下载这些文件是重命名文件/文件夹,然后进行修复/重新安装。

#3


0  

I think that installing/re-installing the SQL Server Data Tools extension for VS 2010 should fix this problem.

我认为安装/重新安装VS 2010的SQL Server数据工具扩展应该可以解决这个问题。

You can download it here:

你可以在这里下载:

http://visualstudiogallery.msdn.microsoft.com/9b0228c6-15d1-44de-9279-66dde12bf861

http://visualstudiogallery.msdn.microsoft.com/9b0228c6-15d1-44de-9279-66dde12bf861