This tutorial will guide you in configuring the most used SQL connection types. Usually a connection to a SQL Server is needed in order to use scripts during your application install process or if it depends on certain database content and configuration.
In this tutorial we will focus only on the settings needed in order to successfully connect to a SQL Server and not to show any other functionality. The tutorial is structured in the following sections and covers the settings for the following servers:
Usually, you want to allow the end-user to fill in all the SQL Server information during install time. In order to do this a new dialog must be inserted in the dialog chain, in which the information can be entered. You can create your own custom dialog or you can use Advanced Installer's predefined SQLConnectionDlg dialog. It is also possible to hard-code your SQL Server connection settings, but this is not recommended as the end-user will not be able to change the connection parameters during install.
- MS-SQL Server Connection
Step by step tutorial on how to set a MS-SQL Server connection.
- MySQL Server Connection
Step by step tutorial on how to set a MySQL Server connection.
- Oracle Database Connection
Step by step tutorial on how to set an Oracle Database connection.
- PostgreSQL Server Connection
Step by step tutorial on how to set a PostgreSQL Server connection.