Database Server Host Settings

InstallAnywhere 2013 » Advanced Designer » Organization » Hosts

When you add a database server host in the Hosts view of the Organization page, you can customize its settings.

The Database Server customizer includes the following settings.

Database Server Customizer Settings

Setting

Description

Server Type

Identify the type of database server with which your installer must interact. Choose from

MySQL
MS SQL Server
Oracle
DB2
Interbase
Firebird
PostgreSQL
Sybase ASE
Generic JDBC Connection.

Note: Generic JDBC connections allow you to interact with database servers InstallAnywhere does not support.

Server Host

Type a URL for your database server. This value must be a valid IP address. For example, localhost, 127.0.0.1.

Note: When the Server Type is Generic JDBC Connection, InstallAnywhere shows the Custom Connection String field instead of the Server Path, Server Port, and Database Name controls. For generic JDBC connections, you must provide a connection string that works for your database server's syntax requirements.

Server Port

Type the port number on which your database server is operating. InstallAnywhere automatically inserts the most common port number for the database server type selected in Server Type.

Database Name

Type the name of the database with which your installer will interact.

Username

Provide a user name for an account with sufficient privileges to complete the database tasks your installer performs.

Password

Provide a password for the database account indicated by Username.

Note: If you enter a password, the password value is automatically encrypted according to the security settings that are specified in the Variables view on the Project page.

Custom Driver Settings

This check box enables your to provide custom values for JDBC Driver Class and Dependencies. InstallAnywhere automatically bundles the default driver and dependencies for the database server selected in Server Type.

JDBC Driver Class

Shows the class for a JDBC driver the database server supports. If Custom Driver Settings is checked, you can edit the value to provide a custom JDBC driver class for your Database Server host.

Dependencies

Shows the libraries currently bundled as dependencies for this Database Server host. If Custom Driver Settings is checked, you can add or remove libraries from the Dependencies list.

Add JAR or ZIP

Opens the Choose Code Archive dialog box. To add a library to the Dependencies list, browse to a JAR or ZIP file that you want to add as a dependency and click Open.

Remove

Deletes the currently selected file from the Dependencies list.

Note: For details on locating database drivers for use with Database Server hosts and Run SQL Script actions, see the following article in the InstallAnywhere Knowledge Base:

http://support.installshield.com/kb/view.asp?articleid=Q113500  

Note: For more information about running a SQL script on a database server, see the Run SQL Script action in Install Actions.

See Also