Help needed to install MSDE and creating a schema?

[btlglobal]

This is what the install program should do ;

1. install MSDE.
A. When I install it manually, I use this command line; setup.exe SAPWD="sapasswd" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL
2. create a database
A. When I did this manually, I used these commands ;
i. <MSDE installation directory>/80/Tools/binn/osql.exe –E
ii. CREATE DATABASE DIREPO
iii. Go
iv. sp_addlogin 'userid','pw'
v. Go
vi. sp_defaultdb 'userid','DIREPO'
vii. Go
viii. use DIREPO
ix. Go
x. sp_grantdbaccess 'userid'
xi. Go
xii. GRANT CREATE TABLE To userid
xiii. Go

3. execute install sequence of my application.



I need an example to install MSDE and sending SQL statements to the MSDE. Can anyone please help me out?

[Absynthe]

I have to do this for my install this week, I'll post what I come up with.

[technobot]

This is what I've used in the past:

File.Run(".\\MSDE\\setup.exe", "/qr+ DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SAPWD=more", "", SW_SHOWNORMAL, true);

You might be better of 'piping' a *.sql script file with all your instruction sets inside.

-T