Windows Forum

Ask something
Discussion Locked

Sql7.0 Client

0 helpful
7 replies

by vatsa

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have installed sql client on the workstations to access the sql server 7.0 on the local network.Now i want to access a similar sql server on the wan, this is part of our colocated server.I have given the proper ip address and server name, but still it does not connect.Any idea what could be the problem?

7 replies

by palmerkh

In your ODBC change your client configuration to TCP/IP instead of named pipes. If you do not have that option on your ODBC, upgrade your ODBC. There is an installation on the SQL Server installation CD for it.

by rsartain

It sounds like the other server may have had SQL 7.0 installed with a different conneting scheme..like Named Pipes instead of TCP/IP or vice versa. You can resolve that using the Client Network Utility that is in the Start Menu option for SQL SERVER. That's a very powerful tool for resolving disparate SQL Server configurations. It's also fairly intuitive. Of course, you'll have to know what the connection parameters are on both machines.

This discussion is closed to new replies.