use sql mdf from application folder

  • Thread starter Thread starter aamirghanchi
  • Start date Start date
A

aamirghanchi

Hi,

I need to deploy my simple windows application to client's pc so that
the database it requires is packaged along with it in the application
folder. I have done it through the setup project but after installation
it throws exception of being unable to acess the database. Please note
that the client does not need to have SQL server installed. I have MS
SQL Server Express and Developer Edition both installed on my m/c. I am
using SQLEXPRESS for database connection strin in my project.

My question is, does the client need to have SQL server installed on
their system?

TIA.
 
Hi,

I need to deploy my simple windows application to client's pc so that
the database it requires is packaged along with it in the application
folder. I have done it through the setup project but after installation
it throws exception of being unable to acess the database. Please note
that the client does not need to have SQL server installed. I have MS
SQL Server Express and Developer Edition both installed on my m/c. I am
using SQLEXPRESS for database connection strin in my project.

My question is, does the client need to have SQL server installed on
their system?

TIA.
Click to expand...

You will need to install SQL server Express on the client's machine.

After doing this do the deploy as you did before. When the user runs
your application the MDF file will be automatically attached to the
SQL Server 2005 instance on the user's machine.
 
Thank you for all the posts. Installing MS SQLEXP on every client m/c
just sounded too radical to me.

The 2 data tables I was using were just for lookup pupose only (no
insert,update) therefore I created 2 XMLs and load them into dataset.

Other than MS SQL is there any database that does not need to have a
server or engine pre installed on client m/c and all their data could
still be accessed from my app. I have not checked MS Access. What is
MDAC?

thanks.
 
JET is overkill for what you describe.
Perhaps SQL Mobile would be better suited.
Frankly, I would use neither. I would save to a delimited file.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top