1. Prepare the MSDE installation file. There is a setup. ini file under the MSDE directory. The content in the file is changed to the following:
[Options]
Securitymode = SQL
Sapwd = sa
Disablenetworkprotocols = 0
The above indicates installation in hybrid mode with the password SA.
2. Package your applicationProgram.
3. create a small program, and there is a form with two single-choice buttons (or buttons). The first text is: Install SQL database, and the second text is: install your program
In the double-click event of the first single-choice button, write: Run (\ MSDE \ setup.exe in the current directory ),
In the double-click event of the second single-choice button, write: run(installation file that you package. EXE)
The generated EXE file is named start.exe, which means double-click the installation of the first SQL database call and double-click the installation of the second application call.
4.then copy the msdefilename folder, the program you pack, and start.exeto a folder. In this example, start.exe will display your interface, which can be installed by double-clicking. it takes a short time to install the database. It takes more than a dozen seconds to complete. after the installation is complete, restart. the SQL Server icon appears in the lower right corner of the screen.
In this way, although it is a little troublesome, it is also very easy to install the database as soon as you double-click it.
You only need to double-click it to install it.
The client does not need to install SQL Server 2000. The INI file is run when the client runs the program. Set the connection server name, database name, user name, and password in the INI file.
If you have any questions, please discuss them.