MDF - Basic Question

microsoft.public.sqlserver.programming

19 May 2006 10:09 AM

S Chapman

Is it possible to 'query' an mdf file using MS Jet Provider or
somethnig like jet provider without having to 'attach' the mdf as a
database on SqlServer. Thanks.

19 May 2006 11:59 AM

Tom Moreau

No. You must have a SQL Server engine to connect to it. You could install
MSDE (SQL Server 2000) or SQL Server Express (SQL Server 2005) and use it.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..

"S Chapman" <s_chapma***@hotmail.co.uk> wrote in message
news:1148033398.353253.150440@i40g2000cwc.googlegroups.com...

Is it possible to 'query' an mdf file using MS Jet Provider or
somethnig like jet provider without having to 'attach' the mdf as a
database on SqlServer. Thanks.