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.
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.
Specify where to browse for the available databases. The name format ca be either <server name> or <server name>\<instance name>.
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.
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.
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.
The logon user name.
The property used at install time to set the logon password. Use thebutton to select it.
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
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.
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.