Gee Vee,
I went to set up a connection on the ODBC Data Source Administrator
and on 'Create a New Data
Source to SQL Server' clicked on 'Client Configuration' . This
allowed me to change the network
library used to communicate with SQL Server. I selected TCP/IP on
this Edit Network Library Configuration window. I tested the
connection and it worked.
Thanks.
> -----Original Message-----
> From: Gee Vee [SMTP:happygv@y...]
> Sent: 27 June 2001 09:43
> To: sql language
> Subject: [sql_language] Re: Connecting
>
> you try to configure the Protocol as same as the
> SQLSRV using Client Network Utility in your Desktop
> tools.
>
> Check the default Protocol thats used by SQLSRV and
> Give the same as default for you system too.
>
> Eg: if SQLSRV uses TCP/IP, use the same in your system
> too. and then try to register SQLSRV in you Enterprise
> Manager.
>
> Let me know if it works.
>
> Regards
> Vijay.G
>
> --- Ntshalintshali Neliso <Ntshalintshalin@f...>
> wrote:
> > <<...OLE_Obj...>>
> > I have installed the desktop components from the SQL
> > SERVER 7.0, but cannot
> > connect to the test server , I get this error. Other
> > users can get to test
> > server. I wonder what I am missing? The server
> > SQLSVR is on the local
> > network, when I do a find on the network I can get
> > to the computer SQLSVR,
> > but connecting to it is something else. I can't
> > even get to it through
> > Query Analyser.
> >
>
> ntshalintshalin@f...
> $subst('Email.Unsub')