SQLOLEDB with Server=(local) on SQL Server 2005
- From: "onedaywhen" <jamiecollins@xxxxxxxxxx>
- Date: 15 Mar 2006 23:58:59 -0800
I've installed MS SQL Server 2005 and my existing ADO code that uses
the OLE DB provider (SQLOLEDB) cannot conntect using '(local)' as the
server/data source name
e.g. these fail:
Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=Airplanes;User
Id=sa;password=MySaPassw0rd;
Provider=SQLOLEDB.1;Server=(local);Initial Catalog=Airplanes;User
Id=sa;password=MySaPassw0rd;
It works when I explicitly use the server name
e.g. this succeeds:
Provider=SQLOLEDB.1;Data Source=MYSERVER;Initial Catalog=Airplanes;User
Id=sa;password=MySaPassw0rd;
I can also get '(local)' to work with the SQL Server native client:
e.g. this succeeds:
Provider=SQLNCLI;Server=(local);Database=Airplanes;UID=sa;PWD=MySaPassw0rd;DataTypeCompatibility=80;
Can anyone confirm whether or not it is possible to use '(local)' with
SQLOLEDB on SQL Server 2005?
Thanks,
Jamie
--
.
- Follow-Ups:
- Re: SQLOLEDB with Server=(local) on SQL Server 2005
- From: onedaywhen
- Re: SQLOLEDB with Server=(local) on SQL Server 2005
- Prev by Date: Re: Ignoring duplicates in BULK INSERT with ADO and SQL Server 2000
- Next by Date: Re: VB6: Which ADO version to reference?
- Previous by thread: Re: Which ADO version to reference?
- Next by thread: Re: SQLOLEDB with Server=(local) on SQL Server 2005
- Index(es):
Relevant Pages
|
|
