open MDF file without MSDE or SQL Server

VivekrkKhare
VivekrkKhare used Ask the Experts™
on
I'm trying to access .mdf file (a sql server database) without having
SQL Server installed on the machine (neither MSDE).
It can be done from any programming language (like C#)?
Is there anyone who knows how can I do it?
Or does a native library that can access the .mdf file exist?

Thank to anyone who can help me...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2014
Commented:
The simple answer is No.

The long complicated answer is that the mdf/ldf/ndf files are proprietary formats specific to MS SQL Server. However, you may want to look at the SQL Server Compact Edition (CE). I think it can be wrappered with other apps/languages.

Author

Commented:
I have 1 application http://www.codeproject.com/KB/database/StartSqlServerEW.aspx
when i run this on my PC with .net, it works fine. but if i installed it on other Machine which not have sql installed, it gives error "getstarted SQL anywhere encountered an error"

let me know if any thing need to install with SQL CE.

Author

Commented:
Thanks, I has been done, I forgot to Add dll reference for CE.
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Most Valuable Expert 2014

Commented:
From that page
--------------------------------------------------
Installing SQL Server Everywhere

First download SQL Server Everywhere from its product homepage.
--------------------------------------------------

It takes you to the same page. That is what will need to be installed along with your app.

SQL Server Compact 3.5
http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx
Most Valuable Expert 2014

Commented:
Glad to be of assistance. May all your days get brighter and brighter.

Author

Commented:
Thanks a lot ! for your instant support

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial