SQL Database Browse

The SQL Databases Browse functionality lists all available SQL Databases from a Microsoft SQL Server. Advanced Installer automatically connects to the server using the provided credentials and enumerates all databases the user has access to.

ODBC Driver

Set the ODBC Driver for the SQL Database Browse functionality. The default value is SQL Server, but it can also be set to ODBC Driver 11 for SQL Server as well as other drivers.

Server

Specify where to browse for the available databases. The name format ca be either <server name> or <server name>\<instance name>.

Login timeout(sec)

You can optionally specify a connection timeout (in seconds) for the browse operation. By typing 0 in this field, the timeout will be disabled and the connection will wait indefinitely.

Verbose

The "Please Wait..." message box for SQL Databases Browse will be shown. Also, if an error occurs when connecting to the SQL Server, a dialog box will be shown containing the error response.

Authentication

Trusted Connection (Windows integrated authentication)

Use a trusted login connection (local/domain). The credentials of the installing user will be used and the Username and Password fields are no longer required.

This option can be enabled at install time by setting the SQL_TRUSTED_CONNECTION property to 1. This property must be set before executing the associated browse action.

Username

The logon user name.

Password

The property used at install time to set the logon password. Use the [ ... ] button to select it.

Output

Advanced Installer can return the discovered available SQL databases either in dialog controls or in an installer property.

Display the result into a ListBox or CheckList control

Specify the installer property associated with a ListBox or CheckList control which will be populated with the available SQL databases.

Display the result into a ComboBox control

Specify the installer property associated with a ComboBox control which will be populated with the available SQL databases.

Put the result into a property

A flat, comma separated list of the available databases (names only) will be dumped into the specified installer property.

Hide system databases

Enabling this option will hide system databases(e.g. master, msdb, etc) from the browse output.

Execution

SQL Database Browse can be triggered by scheduling the associated action in the Wizard Dialogs Stage or by directly invoking the action with a published/init event on a dialog.

Run in UI sequence

Enabling this option will trigger the SQL Database Browse operation when an associated custom action will be executed in the installation sequence. To configure the custom action in the Custom Actions Page, press the Scheduled Action link button.

Attached to an event

Enabling this option will trigger the SQL Database Browse operation when an event is published by a control on a dialog. To configure the event in the Dialog Editor Page, select the dialog and the control and press Control Event link button.