Using VB2005 to create an installer that includes a database

[XiaoToose]

i have this solution that i'm suppose to make an installer of, but because it calls a datebase and the database is not within the solution therefore it was not included in the installer.

and my installer cant work correctly. is there anyway i can go around doing it? pls guide me thanks

[dglienna]

If you made the installer, then you'd have to go back and ADD the db. You can't call the DB from the Installer, as you've found out (the hard way)

David's Lesson #101 of Design - Design should be 90% of the job

[XiaoToose]

so where do i go back and add the data base to?

[dglienna]

Include the DB when you build the program. Use a relative address, so your app can find it. (It should run when you build.) Then, before you compile, you change the SQL Connection Strings to match the LIVE environment