Configuring the Database Connector

You can configure Uniface to access any supported database for the Repository or application data.

The default database used for the Repository and application data depends on the operating system. For MS Windows, SQLite is the default database.For Unix and Linux, Sequential is the default database.

To configure the database connector and database access, edit the application assignment file. By default, Uniface uses the file dbms.asn to configure database access.

  1. Open the file dbms.asn located in UnifaceInstallDir\common\adm.

    This file is included in several other Uniface assignment files, such as ide.asn and wasv.asn.

  2. In the [DRIVER_SETTINGS] section, specify the connector and version, in the format Mnemonic {=} Version.

    If you omit this setting, or specify the incorrect version, the database connector cannot be used.

    For example:

    [DRIVER_SETTINGS]
PGS     U1.4

    where U1.4 specifies the connector version to be used for connecting to PostgreSQL.

  3. Optionally, specify parameters for the connector, in the format USYS$Mnemonic_PARAMS Option {, Optionn}

    For example:

    [DRIVER_SETTINGS]
PGS     U1.4
USYS$PGS_PARAMS identifiers = quoted

    The connector options (parameters) depend on the database and connector. For more information, see the Uniface database connector documentation for your database.

  4. In the [PATHS] section of the assignment file, define a path for the connector in the format:

    $PathName=Mnemonic: {Database} | {UserName} | {Password}

    Note:  To encrypt a path that includes user name and password, you can use the Pathscrambler utility. For more information, see pathscrambler.exe .

    You can then use the $PGS path definition in path redirections. For example:

    [PATHS]
$PGS   PGS:PostgreSQL35W:public|signor|s3cr!349857

$IDF    $PGS  ; Path to Repository definitions for entities.
$UUU    $PGS  ; Path to Repository definitions for runtime libraries.
$SYS    $PGS  ; Path to the Repository definitions for print models.
$DEF    $PGS  ; Path to default DBMS database for user data.

Related Topics