Mastering the Art of SQL Database Navigation and Management

Table of Contents

• Introduction
• Registration
• Using Advanced Installer
  • GUI
  • Working with Projects
  • Installer Project
    * Product Information
    * Resources
    * Package Definition
    * Requirements
    * User Interface
    * System Changes
    * Server
    * Internet Information Services Page”)
    * ODBC
    * SQL Databases
    * Database server
    * SSRS Deployments
    * SQL Operations
    * SQL Database Browse
    * SQL Server Browse
    * SQL Test Connection
    * SharePoint Page
    * Silverlight Page
    * Custom Behavior
  • Patch Project
  • Merge Module Project
  • Updates Configuration Project
  • Windows Store App Project
  • Modification Package Project
  • Optional Package Project
  • Windows Mobile CAB Projects
  • Visual Studio Extension Project
  • Software Installer Wizards - Advanced Installer
  • Visual Studio integration
  • Alternative to AdminStudio/Wise
  • Replace Wise
  • Migrating from Visual Studio Installer
  • Keyboard Shortcuts
  • Shell Integration
  • Command Line
  • Advanced Installer PowerShell Automation Interfaces
• Features and Functionality
• Tutorials
• Samples
• How-tos
• FAQs
• Windows Installer
• Deployment Technologies
• IT Pro
• MSIX
• Video Tutorials
• Advanced Installer Blog
• Table of Contents

Disclaimer: This post includes affiliate links

If you click on a link and make a purchase, I may receive a commission at no extra cost to you.

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 or \.

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 theSQL_TRUSTED_CONNECTION property to1. 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 orCheckList 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.

Did you find this page useful?

Please give it a rating:

Thanks!

Report a problem on this page

Information is incorrect or missing

Information is unclear or confusing

Something else

Can you tell us what’s wrong?

Send message

Also read: