How to Connect .mdf file

Question

0.00/5 (No votes)

See more:

Please help me!
I have mydata.mdf and mydata_log.mdf and I want to connect to mydata.mdf when my pc don't has sql server, so how to I can do this. Please tell me the connect string
Thanks very much!

Posted 24-Dec-11 21:51pm

truongleman

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Dalek Dave** · Answer 1 · 2011-12-24T21:57:00

Solution 1

Firstly, why not just download SQL Server?
Available here[^]

Here[^] is a Stack O thread on the subject.

Posted 24-Dec-11 21:57pm

Dalek Dave

Comments

truongleman 25-Dec-11 5:14am

Thanks, but if My PC don't have enough memory, so how to do this?

Wendelius · Answer 2 · 2011-12-24T23:41:00

The only reasonable way is to install SQL Server, Express edition if you like.

You must understand that when an application connects to the database, it's does not connect to the files. It connects to the database engine (SQL Server service) which is responsible of handling the files. No application or user should never see the files where the data is stored, it's up to the service to take care of them.

This is very different from for example Access, which is simply a shared file manipulated with appropriate drivers from each workstation.

**Manoj K Bhoir** · Answer 3 · 2011-12-24T23:31:00

Solution 3

You can connect your .mdf DataBase file using SQLConnection to application.See this :
connectionStrings
If you want to Connect your Application with SQL DataBase without installing SQLServer
then Just Install required files which are usefull to run Sql Servises.

Posted 24-Dec-11 23:31pm

Manoj K Bhoir