Windows Installer Editor Reference
281
Advanced Installations
Name
A name for the SQL script is generated and displayed here. You can accept the
default or enter a more descriptive name. If you later change this field, the
script file is not renamed.
A file with this name and the extension .SQL is added to the installation.
Connection String
Enter a connection string that connects to a specific Microsoft SQL Server and
database. The default connection string works for most locally installed SQL
Server databases.
If you use the SQL Connection dialog box in this installation, enter the Windows
Installer property WISE_SQL_CONN_STR enclosed in brackets. This property is
populated with a valid connection string when the end user completes the SQL
Connection dialog box and clicks Next.
See
About the SQL Connection Dialog
on page 477.
If your application connects to more than one SQL Server during installation,
add a SQL Connection dialog box for each additional server, edit the additional
dialog boxes, and use a different property for each connection string.
See
Editing Additional SQL Connection Dialogs
on page 479.
The database you specify here must be accessible through ODBC on the
destination computer. If you have a database registered in ODBC on your own
computer, you can click Browse to select it, and the connection string is
generated. For this to work, the destination computer must have access to the
same database.
3. Click OK.
See also:
Tips for Using the SQL Server Scripts Page
on page 280
Specifying SQL Statements
To specify SQL statements
1. Click the Statements tab on the SQL Script Details dialog box.
See
Configuring a Microsoft SQL Server During Installation
on page 279.
2. To import a file containing SQL statements, click Import SQL File and specify a .SQL
or .TXT file that contains SQL statements.
The statements appear on the Statements tab, where you can edit them. If you
later change the file on disk, you must re-import the file to include the changes in
the installation.
3. To generate statements that recreate a database, click Recreate Database.
The Recreate Database dialog box appears.
4. Complete the dialog box:
Connection String
Specify a connection string to the Microsoft SQL Server and database. It must
be accessible to your computer. If it is registered as an ODBC data source on
your computer, click Browse to select it, and the connection string is generated.