Creating a cache

To create a database connection cache for the Oracle database:

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

  2. Enter any text as the cache name.

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

  4. Input the port number.

  5. Enter the Service name.

  6. Use the default TCP protocol; or select the TCPS protocol and then input or select the wallet location.

  7. Enter your User ID and Password for logging into the server.

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

  9. 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.