Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Connecting


Message #1 by Ntshalintshali Neliso <Ntshalintshalin@f...> on Wed, 27 Jun 2001 09:15:31 +0200
	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')

  Return to Index