1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Connect to SQL 2000 with SQL 7 client?

Discussion in 'Networking' started by wquay, Nov 21, 2001.

Thread Status:
Not open for further replies.
  1. wquay

    wquay Thread Starter

    Joined:
    Nov 21, 2001
    Messages:
    1
    I am evaluating a new web hosting firm. They seem good, but they have SQL 2000 servers. I run SQL 7 on my current machine. I can connect to the new database server fine with ASP through an ODBC DSN, but I cannot figure out how to connect via Enterprise Manager, Query Analyzer, or even Access 2000.

    It is going to be a real hassle uploading data without EM or one of the other tools. Microsoft says that connecting via SQL 7 clients should be possible, but I do not understand this information:

    [When using the SQL Server client connectivity components from SQL Server 7.0 or earlier, you must set up an alias using the Client Network Utility before you connect to a named instance of SQL Server 2000. For example, on a SQL Server 7.0 client, to connect to a named instance of SQL Server 2000, you must add an alias that points to \\computername\pipe\MSSQL$instancename\sql\query. If you use an alias name of computername\instancename, clients can connect by specifying this name in the same way as SQL Server 2000 clients do. For the TCP/IP Sockets and NWLink IPX/SPX Net-Libraries, you must use the Client Network Utility to define an alias on the client that specifies the port address on which the named instance is listening.]

    Can anyone enlighten me? Thanks
     
  2. subaruwrx

    subaruwrx

    Joined:
    Jan 12, 2001
    Messages:
    140
    Yes, you can either Add a system DSN for your server, or go into start>programs>mssql7>client network utiliity and create an alias for that server. If you use named pipes, you need to configure one that shows what pipe that server is and the server name. If you are on TCP/IP you just need to add that server name, the IP and port number (usually 1433). If you go to the client network utility, it should be fairly self explanatory. After you add this there, you should be able to connect with enterprise manager.
    Hope this helps
    --Adam
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/59181

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice