Hi!
1) The installer for MSDE has a command-line switches to allow install it in the "silent" mode without any messages or whatever. So you just have to run the installer in such mode. Read docs on MS site (as far as I remember, I found information about this there).
2) Just run SQL script using, for example, VFP app and SQLExec() command with string containing the script. There are also a command-line utility for SQL Server (I do not know really if they provided with MSDE) that allow to do the same. However, all "GO" commands in the SQL script should be removed and each block of commands between "GO" should run in separate call to server.
HTH.
>OK, I've created a client server application and want to install it on a client's machine. They do not have SQL Server, so I want to give them MSDE.
>
>1) How do I set it up on their machine? Is there a merge module that I can include in InstallShield express to have it installed automatically with the application?
>
>2) What is the best way to get the database set up once I get MSDE installed?
>
>I would like for this to all be automated. I cannot go to every clients office and set this up manually for them!
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.