Click here to Skip to main content
15,903,801 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more: , +
I am creating a window application that need to use sql server database. I want to install this application to client machine without installing sql server so that my application can still connect to a database i.e mdf file that i will be providing at client system.

How can i connect to a database(mdf) on client machine through my window application without installing sql server. ? I dont know is it possible or not.

Client mahine dont need any installation.
Updated 5-Jan-16 16:53pm
PIEBALDconsult 5-Jan-16 22:55pm    
The database will need to be on a server somewhere. If there is a server you can use, then you needn't install SQL Server on the client.
If not, then maybe you want to use SQL Server Compact instead.

1 solution

You need SQL to connect to the MDF. You can convert it to an SDF and load the compact edition (free).

SQL Compact
Share this answer
iamvinod34 6-Jan-16 0:24am    
please send any link...
how to use sql compact tutorial
Member 12231063 7-Jan-16 21:00pm    
sql compact is very slow(base on my experience) and have many limitation.
Member 10584397 10-Jul-17 5:22am    
use ODBC connection

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900