Agreed. Good answer.

Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: RRazzano
[mailto:mssqldba-ezmlmshield-x73004304.[Email address protected]
Sent: Friday, July 30, 2004 8:49 AM
To: LazyDBA Discussion
Subject: RE: Client connectivity

Make sure the version of MDAC is up to date on the client pc. If you
look at the version of the sql server driver in the ODBC control panel,
it should begin with 2000. If not, install a later version of MDAC.
Pre-2000 versions of the sql driver cannot connect to named instances,
regardless of how you specify them.

-----Original Message-----
From: Thomas Anthony
[mailto:mssqldba-ezmlmshield-x35704294.[Email address protected]
Sent: Thursday, July 29, 2004 8:55 PM
To: LazyDBA Discussion
Subject: RE: Client connectivity


By default, SQL Server listens to request for port numbers on UDP 1434;
so, you do not have to specify a port specifically. It's called dynamic
discovery.

As for the connection, just specify the Host (aka, Server, or Data
Source) as <Server Name>\<Instance Name> just like you've specified it
below without the leading \\.

That's it.

Sincerely,


Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: rsf_consulting [mailto:mssqldba-ezmlmshield-x16282263.[Email
address protected]
Sent: Wednesday, July 28, 2004 9:56 PM
To: LazyDBA Discussion
Subject: Client connectivity

Hi ppl,

Got an issue here I have one server wiin 2000 advanced server sp3 with
sql
server 2K sp3. I have set up 4 named instances on this box.

\\server\instanceA
\\server\instanceB
\\server\instanceC
\\server\instanceD

Now my problem is I need to connect to them using ODBC on a pc that does
not
have SQL Server Clinet in stalled just the standered MDAC and ODBC
drivers. How
do i connect as currently it wont work even thought I have specified the
port
that particular instance is connecting to .

And iseas would be greatly appreciated.

Thanks



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************

MS Sql Server LazyDBA home page