Creating a cache

To create a database connection cache for the Informix database:

  1. In the Database Configuration dialog box, select Informix from the Provider list.

  2. Enter any text as the cache name.

  3. Input your IP address or your machine name to Server.

  4. Input the port number (9089 by default).

    This port number should be the TCP port number for the DRDA protocol (not the SQLI protocol).

  5. Enter your User ID and Password.

  6. Enter your database name to Connect to a database.

  7. Select the check box of "I have read and agree to the license ...".

  8. Click Test Connection to make sure the connection is successful.

    The "Allow dynamic connection using the transaction LogID and LogPass" option allows the application to use the LogID and LogPass property values of the Transaction object to log in to the database server (instead of using the values in the User name and Password fields). For more, refer to Using LogID and LogPass properties.