Sql Native Client - Can't reach by instance name
- From: Kevin Chambers <KBChambers@xxxxxxxxx>
- Date: Wed, 26 Sep 2007 23:31:29 -0000
Hi there--
I'm connecting to SQL Server Express from MS Access via ADO on a
number of older workstations. Of three workstations, two connect just
fine with a connection string like this:
Provider=sqlncli;Network Library=DBMSSOCN;Initial Catalog=MyDb;Data
Source=server\sqlexpress;Integrated Security=SSPI
However, on one machine (W2K), the above does not work, but this does:
Provider=sqlncli;Network Library=DBMSSOCN;Initial Catalog=MyDb;Data
Source=server,2295;Integrated Security=SSPI
There appears to be a problem with getting the connection redirected
to the named instance. It seems like the native client driver should
be all I need for this to happen, but it ain't. Anyone know what's
missing here?
Thanks in advance for any help.
KC
.
- Follow-Ups:
- Re: Sql Native Client - Can't reach by instance name
- From: Tibor Karaszi
- Re: Sql Native Client - Can't reach by instance name
- Prev by Date: Re: Timeout expired. The timeout period elapsed prior to completion o
- Next by Date: RE: SQL 2005 Compact Edition - Derived tables
- Previous by thread: Re: Timeout expired. The timeout period elapsed prior to completion o
- Next by thread: Re: Sql Native Client - Can't reach by instance name
- Index(es):
Relevant Pages
|
Loading
