Re: OLEDB connection string for .MDF (?)
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 12 Jul 2006 22:14:29 +0000 (UTC)
(tommaso.gastaldi@xxxxxxxxxxx) writes:
I just cut and past the string from the VS designer. User
Instance=False would be perfectly fine.
My question was about the possibility of using the standard SQL Server
OleDb provider
to access an .MDF file.
If it where possible, it would be very useful for my purposes. I have
done a lot of attempts but either I could not figure out the right
connection string, or SQL OleDb provider does not support .mdf files:
"Provider=sqloledb;Data Source=" ... ";User ID=" & UserId &
";Password= ????
I just need a local connection. Not remote. The .mdf file is assumed to
be on the server.
AttachDBFileName is indeed recognized by SQLOLEDB.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: OLEDB connection string for .MDF (?)
- From: tommaso . gastaldi
- Re: OLEDB connection string for .MDF (?)
- References:
- OLEDB connection string for .MDF (?)
- From: tommaso . gastaldi
- Re: OLEDB connection string for .MDF (?)
- From: Erland Sommarskog
- Re: OLEDB connection string for .MDF (?)
- From: tommaso . gastaldi
- OLEDB connection string for .MDF (?)
- Prev by Date: Re: Data concept
- Next by Date: Re: OLEDB connection string for .MDF (?)
- Previous by thread: Re: OLEDB connection string for .MDF (?)
- Next by thread: Re: OLEDB connection string for .MDF (?)
- Index(es):
Relevant Pages
|
|
