[RESOLVED] database error in CAB file

[husky_doggy]

i used SQL Server Compact 3.5 for create my connection and all datatable..
and debug fine....
but after I done the CAB file and install it on my phone....
all the forms with datatable just get an error..."database file can not be found" it said..

did i missed anything in the procedue??!

for the mean while i found myself a solution ...and that is ...I copy the temponary debug .sdf file to my installed project..

but surely..there is a formal way?

HELP....

[petevick]

What is your code for creating and opening the database?

[husky_doggy]

What is your code for creating and opening the database?

i just used its add> add new data source.
and drag the table to the form to create the tableadapter...

[petevick]

so where does your database come from in the first place?

[husky_doggy]

so where does your database come from in the first place?

I created it in Server explorer in my vb project

[petevick]

so you need to deploy it with your app - it sounds as though you are not doing that

[husky_doggy]

yea..thats the thing...
i know i need to build the sdf file along wiv the project itself...
but i cant find any option to do it..

[petevick]

Add a 'setup project' to your project, and add the database to that setup project and it will be deployed when you deploy the setup.

The setup project can also deploy the compact framework, SQL compact etc