yronium Level: Moderator

 Registered: 14-04-2002 Posts: 907
|
Re: MSDE
I can say it for certain: it's the same of SQL Server.
But I didn't understand what are you attempting to do. In the setup packet you have to put your executable, not any database.
Perhaps you might want to create a database into the MSDE server: that case you got to provide an sql script to run.
Perhaps you might want to provide some data to an existing MSDE database: so you got to provide a backup file to restore, and an sql script to execute restoring.
But running sql scripts is not expected to be done by the setup packet, as it is a separated operation than the bare setup process, or at least I don't know how could we make InstallShield automately do it.
I can tell you how to write a small VB application that launches the sql scripts, and that's what I do: I create a setup pack with all the files, but I don't launch it directly. Instead, I run a small app that first launches the setup pack and then run the scripts. Alternately, you can run the scripts at the first execution of your main app, but that's it. I have not the skill to program InstallShield (nor VSI, that's what I use) to do it automatically, and I think few have it.
Hope it helps, ask if you need to know more on what I said.
____________________________
Real Programmer can count up to 1024 on his fingers
|