Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    184

    Question Unanswered: SQL 6.5 Client Tools And MSDE????

    Hello everybody,

    I have the SQL 6.5 client tools installed on my machine, I also have MSDE installed. However the client tools do not see the MSDE. I keep getting the error message that I have attached to this message as a gif. Anybody have any ideas it would be appreciated.
    Attached Thumbnails Attached Thumbnails error.GIF  
    In abundance of water only the fool is thirsty. Bob Marley.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    MSDE is a stripped-down version of SQL2K. Client tools for 6.5 will not be able to connect to it. You'll need Client Tools for 2K to be able to use QA against both, but EM for 2K will also not work against 6.5, so you'd have to use corresponding versions of EM to connect to 2K and 6.5.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jan 2004
    Posts
    184
    Thank you for your reply. However according to this artcile I found on MSDN:

    http://support.microsoft.com/default...b;en-us;265808

    It is possible to use SQL 6.5 Client tools on MSDE. But I followed the steps in the article it still didn't work. Any other ideas would be appreciated, thank you again.
    In abundance of water only the fool is thirsty. Bob Marley.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    MSDE allows for named instance only, which QA from 6.5 cannot reach. If you failed to create an alias (see your article), you're still in the same boat.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Jan 2004
    Posts
    184
    What do you mean by named instance? Is there any way around this? So there is no way not even ISQL/w can be used? Thank you again for your answers.
    In abundance of water only the fool is thirsty. Bob Marley.

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    <server_netbios_name>\<instance_name>
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •