Post reply

SQL 2000 and SQL 7.0 on same server

  • May 5, 2006 at 8:30 am

    #90903

    I installed SQL 2000 on my notebook. Recently I had to install SQL 7.0 on my notebook as well. Apparently you can install both versions on the same machine. I installed SQL 7.0 on a different drive. However, when I launch SQL 2000 Enterprise manager I receive the following message: The procedure entry point ?UpCast@CDMOQUeryInterface@@SAJPAUIWSQLDMODatabase@@PAPAUIWSQLDMODatabase2@@Z could not be located in the dynamic link library SEMCOMN.dll. The application then closes.

    Any ideas?

  • May 5, 2006 at 8:38 am

    #636265

    Did you already try to reinstall the Client tools?  This will probably fix your problem with EM.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • May 5, 2006 at 10:50 pm

    #636394

    i'm under the impression that SQL7 must be installed first as a default instance.

    after that is installed, you could install either/both SQL2000 and SQL 20005 as named instances on the machine.

    i think you need to save your backups and mdf files, uninstall everything from SQL, and reinstall with SQL7 first, then SQL 2000, then restore and reattach databases.

     

    I'm sure that when you installed SQL7, it overwrote portions of the default install and screwed things up.

     

    On my machine, I have all three versions installed, in the order above; so i've got SQL7 as the default instance, and named instances of machinename\SQL2000 and machinename\SQL2005

     

     

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 2, 2006 at 4:53 am

    #641380

    Thanks Luke and Lowell,

    I have opted to uninstall everything. I then installed SQL7.0 as the default instance and then installed SQL2000. All the applications that use SQL7.0 and SQL 2000 work 100%

    Thanks again for the help

Viewing 4 posts - 1 through 3 (of 3 total)

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