Database Open Action

Last Updated : Jan 23, 2023 |

Database Open action opens a link to a database. If there is a connection to the database already then the current connection is closed and the new one requested will be opened. For an example of the action in a call flow, see Retrieving Data From the Database.

Procedure

  1. Click the Database Actions icon.
  2. Click on the callflow where you want the action placed.
  3. Connect the new action to the required result of a preceding action.
  4. Select Database Open.
  5. Double-click on the action to display its settings tabs.
  6. The General, Entry Prompts, Reporting and Results tabs are standard tabs available to all actions. See The Start Action and Action Settings Tabs.
  7. Select the Specific tab. The connection string to open the database can be entered directly into the field. For help on constructing the connection string, click . The Data Link Properties window opens.

    Tab

    Description

    Provider

    Select the OLE DB Provider of the data that is to be connected to. Click Next to move to the Connection Tab.

    Connection

    Specific information relating the Database provider needs to be completed. The fields available depend on the type of provider.

    • To test that the information entered, click Test Connection. A Test Connection Succeeded message indicates successfully database connection.

    • The voicemail server uses MD5 authentication. Other methods of authentication such as SCRAM are not supported.

    Advanced

    Network and other settings, for example access permissions. Fields showing will be dependent on the type of provider selected. Click help for specific information about any of the fields.

    All

    The properties that have been selected on the previous tabs are shown in the All Tab. Amendments can be made as required by selecting the Name and click Edit Value.
  8. Click OK.
  9. Connect the action's results to following actions as required.

Result

This action has the following results which can be connected to further actions:

  • Success: This result connection is used once the database is opened.

  • Failure: This result connection is used if the database cannot be opened.

Related information
Database Actions