Post reply

Database Diagram window opens empty

  • January 20, 2005 at 8:21 am

    #87447

    This question may have been asked before and I apologize for repeating it. Just can't find it when I search for it:

    When I open a database diagram created by another user, it opens blank... I can create one and re-open it.

    I re-installed SP3a with patch 819.... (our standard at the moment @ work)

    What gives?

  • January 20, 2005 at 10:15 am

    #538355

    Are you sure it's empty.  I've seen it where you have to use the scroll bars on the screen to find the objects.

    Let us know.

    Tom

     

  • January 20, 2005 at 11:47 am

    #538371

    There are no scroll bars. We even played with the "zoom"

  • January 21, 2005 at 2:41 am

    #538457

    check for rows in dtproperties table

     

    select * from dtproperties

    if there are no rows in dtproperties table, then you cannot open the diagram

  • January 21, 2005 at 5:49 am

    #538480

    There are rows in the table.

    I can open the diagram from another WS, but not mine.

    As I mentioned I re-applied SP3a with Security patch MS03-031. Did not work.

    Do I have to re-install SQL Tools?

  • January 21, 2005 at 6:33 am

    #538497

    According to this page, http://users.spark.net.gr/~yiapap/bldiagra.htm, seems that it is caused by ADO 2.8.  I haven't tried it yet.

  • January 21, 2005 at 6:48 am

    #538500

    Just a follow up, the fix from the link works.  You will have to close EM and reopen it for it to work.

  • January 21, 2005 at 7:08 am

    #538505

    Talk about MS integration!!!!! (read MIS-integration)

    I never would have known to look at this.

    Thanks so much!!! it solved the problem.

     

     

  • January 30, 2005 at 6:02 pm

    #539672

    OK this definitely DID NOT work for me -- this is what I'm running...

    Microsoft SQL Server  2000 - 8.00.194 (Intel X86)

     Aug  6 2000 00:57:48

     Copyright (c) 1988-2000 Microsoft Corporation

     Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

    I am using .NET 2003.

    Old diagrams open with nothing to see, new diagrams work for a while and then disappear the same way. Why is that?

  • January 31, 2005 at 6:04 am

    #539711

    First, your SQL Server version sould be at least 818, which is SP3a with MS03-031 patch (a MUST to protect yourself against the Slammer virus). Try that and see...

    Second, my guess is with a conflicting DLL from .NET.

    I'd try the MSSQL update first...

    I am running .NET 2003 AND I can see the diagrams no problemo.....

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply