Help Publishing project

[mattrix]

Hey guys, its been a long time since i did computing for A-level. basically ive created a program in VB 2008 and i cant remember how to publish it in such a way that it includes the database that the program uses. At the moment when i publish it, it only works on my system because i have the database on my PC, if i delete the database from my pc the program messes up because it doesnt have a copy of the database in its program resources etc.

how do i publish the program so that it includes a copy of the database that it needs to function?


Many Thanks,

Matt.

 

[xpertwinner]

same

i have the same problem.. I have successfully published my project.. but i don't know how to include de database itself.. I have read the following tutorial on how to automatically install a local sql server with the application, but still I don't know how to include de database..

Application Deployment with Shared and Private Deployments (VB)

 

[mattrix]

The only way i found to do it is by deleting the connection string and then making a new one but when it asks do you want to make a copy of the database in the project folder, say yes, then when it publishes it includes the database, but its a very long way round of doing it and can create a lot of problems with more complex projects.

 

[xpertwinner]

reply

and where exactly would you do that? in the project settings? and how could i then put like a relative path in the connection string so that it would work on any computer? thanks a lot

 

[xpertwinner]

well.. i did the following and it worked:

In the program the connection string points to a database local server ( ./sqlexpress) and in the destination computer I installed sql server and attached the database..

 

[korae]

what if you're using msaccess database how will you include it during publish?

 

[JuggaloBrotha]

what if you're using msaccess database how will you include it during publish?

I deploy app's with Access databases all the time, follow jmc's post in your vbforums.com thread.