Discussion Locked

first client to sql connection

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have installed MS SQL 7.0 standard edition
on my test server. I have installed the
client utitlies on my Win2K workstation. How
do I connect to the sample datbases
(Northwind) from my client?
Using SQL commands I can query the database
from the server so I know the SQL server is
running but how do I confrim that I can
coonect to a database?

5 replies

by msullivan

Try using SQL Query Analyzer. You can also use the ODBC driver to test connectivity or access the data from MS Office apps.

Hope this helps.
Mike

by gutridgesj

if you install the sql 7 client utils on the client pc, ie query analyzer and enterprise mgr, you can connect that way.

if not, use Access and ODBC to connect

This discussion is closed to new replies.