none
How to Connect with SQL server Database without install SQL server

    Question

  • Hi

    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. ?

     

    Thanks

    Sunday, August 14, 2011 2:56 PM

Answers

  • You basically have 2 options:

    1) Use SQL Compact Edition and package the dlls with your application.

    2) Install SQL Express with your application, it is a simple silent install and load the file using your connectionstring

    And there is still a 3rd option, but I guess it doesn't fit your requirements:

    3) Connect to a centralized SQL Server database running on a separate server which serves all your clients.

    • Marked as answer by Paul Zhou Tuesday, August 23, 2011 7:08 AM
    Sunday, August 14, 2011 7:15 PM

All replies