General discussion

Locked

Sql7.0 Client

By VATSA ·
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?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Sql7.0 Client

by anthony.biondo In reply to Sql7.0 Client

Try checking your network settings and making sure they are set to TCP/IP and not Named Pipes.

Collapse -

Sql7.0 Client

by VATSA In reply to Sql7.0 Client

The question was auto-closed by TechRepublic

Collapse -

Sql7.0 Client

by palmerkh In reply to Sql7.0 Client

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.

Collapse -

Sql7.0 Client

by VATSA In reply to Sql7.0 Client

The question was auto-closed by TechRepublic

Collapse -

Sql7.0 Client

by rsartain In reply to Sql7.0 Client

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.

Collapse -

Sql7.0 Client

by VATSA In reply to Sql7.0 Client

The question was auto-closed by TechRepublic

Collapse -

Sql7.0 Client

by VATSA In reply to Sql7.0 Client

This question was auto closed due to inactivity

Back to Windows Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums