8.1.5 Database

These options control whether the package will check for the existence of a database and the connection to the database.  The database options are only relevant if the deployed application uses a local database.

The installation and upgrade of Sybase ASA databases is no longer supported by the Deployment Tool.

For more information on the X_RUN database arguments refer to The DBID, DBUT, DBII and DBIT Parameters in the Technical Reference Guide.

Setup Database (SUDB)

This value is typically set as Yes. 

Web Application Server install, SuperServer Server install and Standalone installs would set this to Yes.

Exceptions are instances where multiple installs access the same shared database. In such a case, it's up to the installer to check this option in the install dialog for the server and leave it unchecked for the clients.

For example, installing a Corporate Application, that is an Application using a shared database, only the first installation of the Application onto a user's PC will require the database to be setup as part of the installation processing. To help end-users install it correctly, the setting should be set to No so that only the Administrator installing it for the first time would need to change the default setting. The Administrator may even install it directly on the Database Server, even though it will not be executed there, just to have a restricted location to install it to.

It's also possible to set it to No and not allow it to be changed in the Local Database Dialog. Then it can only be changed to Yes by running it from the command line. This gives the best protection against inadvertent Database Setup.

To allow the first installation to override the setting of No, the option to Prompt during Installation should be selected.

Yes – Install tables and table data shipped with the Version or Patch into the nominated database.  This will not create the database.

No – The database is not modified.

Default: No

DBMS Type (DBUT)

Select the DBMS type you wish to install into from the List.

No Database 

MS SQL Server 

Oracle 

Sybase ASA 

Default: No database.

If this option is set to No Database the install processing will automatically set DBII=*NONE and all other database options will be ignored.

Data Source Name (DBII)

The Data Source Name for the database to receive the package.

Default: [Default]

If no database is required leave the Data Source Name (DBII) as [Default] and set DBMS Type (DBUT) to No Database.

If the Data Source Name is set as [Default] the install will attempt to create a Data Source Name using the Application Description.  If a Data Source Name already exists with this value this Data Source Name will be used.

 

Database User (DBUS)

The Database User to be used for connection to database.

Default: [Default]

If the Data Source Name supplied is already defined on the target system, and the Database User is set as *DEFAULT, the Database User will be derived from the existing Data Source Name.

If the Data Source Name supplied is already defined on the target system, and the Database User is set to a value other than *DEFAULT, the Data Source Name definition will be updated with the Database User supplied.

If the Data Source Name supplied does not exist, the package installer will create the Data Source Name using the Database User and Database Password supplied.  When the Database User is set to the special value *DEFAULT the User will be set as follows:

MS SQL Server – sa 

Oracle –  SYSTEM 

Sybase ASA (all versions) – DBA 

 

Database Password (PSWD)

The password to be used for connection to database

Default: [Default]

If the Data Source Name supplied is already defined on the target system, and the Database Password is set as *DEFAULT, the Database Password will be derived from the existing Data Source Name.

If the Data Source Name supplied is already defined on the target system, and the Database Password is set to a value other than *DEFAULT, the Data Source Name definition will be updated with the Database Password supplied.

If the Data Source Name supplied does not exist, the package installer will create the Data Source Name using the Database Password supplied.  When the Database Password is set to the special value *DEFAULT the Password will be set as follows:

MS SQL Server – "" (Empty string)

Oracle – MANAGER  

Sybase ASA 9 – SQL  

Sybase ASA 10 – sql  

Sybase ASA 11 – sql  

 

Database Server Name

The name of the database server.

Default: [Default]

If a new Data Source Name is generated by the package installation a value of *DEFAULT will set the Database Server Name to the same value as the Data Source Name.

If a pre-existing Data Source Name is being used a value of *DEFAULT will use the Data Server Name from the existing Data Source Name.

Database Name

 

The database name to use when installing into an Adaptive Server Anywhere or MS SQL Server database.

Default: [Default]

If a new Data Source Name is generated by the package installation the default will set the Database Name to the same value as the Data Source Name.

If a pre-existing Data Source Name is being used a value of *DEFAULT will use the Database Name from the existing Data Source Name.

Use Trusted Connection

This allows the user to specify if Windows Authentication should be used when connecting to a MS SQL Server Database. This option is only relevant for MS SQL Server or Sybase ASA databases.

Yes - Use Windows Authentication. In this case the Database User and Database Password will be ignored.

No - Do not use Windows Authentication. In this case the Database User and Database Password specified are used to connect to the database.

Default: Yes