![Symantec WINDOWS INSTALLER EDITOR 8.0 Reference Download Page 259](http://html.mh-extra.com/html/symantec/windows-installer-editor-8-0/windows-installer-editor-8-0_reference_1418944259.webp)
Windows Installer Editor Reference
259
Advanced Installations
See also:
Configuring a Microsoft SQL Server During Installation
on page 257
Setting SQL Connection Strings
To set SQL connection strings
1. Click the Connection tab on the SQL Script Details dialog box.
See
Configuring a Microsoft SQL Server During Installation
on page 257.
2. Complete the dialog box:
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 426.
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 428.
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 258
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 257.
2. To import a file containing SQL statements, click Import SQL File and specify a .SQL
or .TXT file that contains SQL statements.