How To Access .mdf File From Client machine

Question

1.00/5 (3 votes)

See more:

I want to know that if i install simply a software that developed in c#.net (sqlserver 2014) as backend. How can i access sql server from other computers without installing sql server, because iam using sql server database through .mdf file which need no installation of sql server. So i don't want to install sql server for making client server.

Posted 23-Jan-16 6:00am

iamvinod34

Updated 23-Jan-16 6:06am

PIEBALDconsult

v4

Add a Solution

Comments

Philippe Mori 23-Jan-16 14:13pm

As other answers already suggest. You have essentially 2 possibilities. Either the database is on the client and the client SQL server to be installed or the database is installed on the serveur and the client either connect directly to it or indirectly through a web service or something similar.

By the way, the question is hard to understand. Maybe English is not your first language but it is still hard to figure out how client and server are related and if you have one database or many.

PIEBALDconsult 23-Jan-16 22:02pm

Ah, I see now this is a repost.
http://www.codeproject.com/Questions/1069517/Connecting-to-sql-server-database-mdf-file-without?arn=0

TenmanS14 25-Jan-16 6:41am

maybe look at SQLite...

https://www.sqlite.org/about.html

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

2 solutions

Solution 1

No problem. You do not need to install SQL Server on the client, you simply use the connection string to specify which server and database to connect to.

SQL Server connection strings - ConnectionStrings.com[^]

You and your admin will need to ensure that the server and database are accessible.

Posted 23-Jan-16 6:09am

PIEBALDconsult

Comments

iamvinod34 23-Jan-16 21:48pm

plz read solition 2...
dave krekowiak do not access without install sql server answer told...
you no need to intall sql server answer told ....
which is correct?

PIEBALDconsult 23-Jan-16 22:03pm

Both are correct. And the feedback you received on your earlier question is correct.

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)

Dave Kreskowiak · Accepted Answer · 2016-01-23T06:54:00

You've already asked this question before. Try not to ignore the answers this time.

You can NOT use an .MDF file without SQL Server. It either has to be installed on the client if you're going to have just the single machine accessing the database

OR, if your application is going to be used from multiple client machines, you have to install SQL Server on a server and then that SQL Server uses the .MDF file. Your code then uses a different connection string to connect to the remote SQL Server.

That's it! Those are your options.