use sql mdf from application folder

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.

Earl
Sun Jan 01 11:29:17 CST 2006

Yup. That would be SQLExpress.

<aamirghanchi@yahoo.com> wrote in message
news:1136079006.936820.25090@g14g2000cwa.googlegroups.com...
> 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.
>

Otis
Mon Jan 02 09:23:12 CST 2006

On 31 Dec 2005 17:30:07 -0800, aamirghanchi@yahoo.com wrote:

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

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.

aamirghanchi
Thu Jan 05 12:46:49 CST 2006

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.

Earl
Mon Jan 09 11:24:14 CST 2006

You might want to look into creating .dbf freetables.

<aamirghanchi@yahoo.com> wrote in message
news:1136486809.135019.193640@g47g2000cwa.googlegroups.com...
> 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.
>

William
Mon Jan 09 11:41:37 CST 2006

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

"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:Ox07%23FUFGHA.2704@TK2MSFTNGP15.phx.gbl...
> You might want to look into creating .dbf freetables.
>
> <aamirghanchi@yahoo.com> wrote in message
> news:1136486809.135019.193640@g47g2000cwa.googlegroups.com...
>> 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.
>>
>
>