Voicemail Pro Installation and Maintenance Page 250
15-601063 Issue 22e (16 May 2010)IP Office Release 6
4.10 Database Actions
Database Actions
These actions relate to retrieving and adding data to a database.
·In addition to the normal licenses for Voicemail Pro , use of database actions requires the IP Office system to
have an Advanced Edition license. For systems upgraded to IP Office Release 6, existing legacy VMPro Database
Interface licenses can still be used.
· Database Open Action
Open a database.
· Database Execute Action
Perform an action on a database.
· Database Get Data Action
Get information from a database.
· Database Close Action
Close a database.

4.10.1 Database Open

The 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 IVR
Database Connection Example, Retrieving Data From the Database .
·In addition to the normal licenses for Voicemail Pro , use of database actions requires the IP Office system to
have an Advanced Edition license. For systems upgraded to IP Office Release 6, existing legacy VMPro Database
Interface licenses can still be used.
Settings
1.Click the Database Actions icon and select Database Open.
2.The General , Entry Prompts , Reporting and Results tabs are standard tabs available to all
actions.
3.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.
·Provider Tab
Select the OLE DB Provider of the data that is to be connected to. Click Next to move to the Connection Tab
.
·Connection Tab
Specific information relating the Database provider needs to be completed. Help of the information required for
each of the fields can be obtained by clicking the Help button. Fields available will be dependant on the type of
provider. Test that the information entered will allow entry into the database, click the Test Connection button.
A message Test Connection Succeeded will show if successfully connected to the database.
·Advanced Tab
Network and other settings, for example access permissions. Fields showing will be dependant 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.
Results
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.

22
250
251
252
253
366
22
176 177 182 183