Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Apollois
Starting Member
49 Posts |
 Posted - 2004-07-29 : 18:04:14
|
| Greetings,What would cause, and how do I fix, an existing DB diagram to be blank whenI attempt to view it from a new install of Enterprise Manager? I do NOT getany error messages. I can view the diagram fine on the SQL Server machine,and from other client machines where I have the SQL Server tools installed.Client Machine (where I'm having the problem):================================ WinXP Pro SP1 (clean install) SQL Server 2000 SP3a Client Tools (Enterprise Manager, Query Analyzer) Visual Studio .NET 2003 This machine is a clean install of everthing. Did NOT have any priorversions of any software installed.SQL Server Machine================= Win2000 Advanced Server SP3 SQL Server 2000 SP3aI can create a new diagram (in the same DB) and view it fine.I have tried re-installing SP3a on the client machine but didn't help.I have searched the KB, and the only article I found that relates in any waystates that I must have db_owner role. I was already set as "SystemAdministrator" role, but just to be sure I added my account as "db_owner"role for this DB. It didn't help.Any ideas?TIA.Best Regards,Jim |
|
|
Apollois
Starting Member
49 Posts |
Posted - 2004-07-31 : 23:35:47
|
| I just found this fix:http://www.yiapap.com/bldiagra.htm ==============================================Fixing the Blank Diagram problem in SQL Server 2000 Enterprise Manager after installing SP6 for Visual Studio 6.I have had this problem for a while now, after installing SP6 and ADO2.8 on a WinXP machine.SQL Server's Enterprise Manager showed all Database Diagrams as blank, even if when I opened them from another PC they appeared OK.The fix is:Locate MDT2DF.DLL (default location= C:\Program Files\Common Files\Microsoft Shared\MSDesigners98). The SP6 version is 2.0.0.9586.This is the DLL that causes the problem. Find the same DLL from another PC with SP5 or extract it from the SP5 archives and check the version. It should be 2.0.0.8958(For those who cannot find this version, I've uploaded it here) Now rename the SP6 version as MDT2DF.DLL.OLD and copy the SP5 version into the MSDesigners98 directory. I can't say for certain (I did it anyway) but you may need to re-register it. From Start-->Run, type:regsvr32 "C:\Program Files\Common Files\Microsoft Shared\MSDesigners98\MDT2df.dll"============================================== This worked for me.Didn't even have to reboot. :-)Best Regards,Jim |
 |
|
|
|
|
|
|
|
Blank DB Diagram in new Enterprise Manager instal