Geek Answers Handbook

I cannot create a database diagram in VS2010 for SQL Server Express

For some reason, when I click Add Diagram in Server Explorer, I leave a blank tab for diagramming. However, there is no dialog box that usually asks which tables to add. The drop-down menu at the top, called Diagrams , also has all the buttons inactive.

What could be the reason?

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

+8
sql-server visual-studio-2010
source share
3 answers

I switched to Visual Studio 2012, and I can build charts there. VS2010 on the same machine still has problems. VS2010 on my other computer - no problem. Still don’t know what the problem is.

+2
source share

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

contains information that installing a new beta version installs the visual database tools for 2012, but when uninstalling it will not return the previous version. There were two places for the files that needed to be replaced. The directory and the name of the DLL file (on an X64 machine): C: \ Program Files (x86) \ Common Files \ microsoft shared \ Visual Database Tools \ dsref80.dll There is a link to the dll in the wiring.

There was also a second folder that 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 Catalog and the DLL file name (on an X64 machine): C: \ Program Files (x86) \ Common Files \ microsoft shared \ MSDesigners8 A file replacement was also downloaded.

Another option, instead of downloading these files, is renaming files / folders and then restoring / reinstalling.

+1
source share

I think that installing / reinstalling SQL Server Data Tools for VS 2010 should fix this problem.

You can download it here:

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

0
source share

More articles:


All Articles