DB Open Block
Connects the voice application to a specific database.
The Open Database block has one conditional exit, DB Open Failed, which directs the flow of the voice application if the database does not open, which may occur if there are connectivity issues of the database is offline.
The Open Database block has the following settings:
•Label (Required) - The name of the database connection. You can use any name.
•Connection Name for AppBuilder (Required) - The ID or description of the database the block opens. You can use any name.
•Connection String (Required) - The OLEDB connection string for the database. Ivanti Voice uses Microsoft ActiveX Data Objects (ADO) connection strings to connect to databases. These connection strings identify the data source, database, and authentication properties necessary to access a database.
MS SQL connections can be authenticated through Integrated Security or SQL user accounts created by a SQL administrator on the SQL Server instance.
Examples: The following are sample ADO connection strings using the OLE DB Provider for MS SQL.
For Standard Security:
Provider=SQLOLEDB.1;Data Source=myServerName; Initial Catalog=myDatabaseName; User Id=myUsername;Password=myPassword
To Connect to a Named Instance:
Provider=SQLOLEDB.1; Data Source=myServerName\myInstanceName; Initial Catalog=myDatabaseName; User Id=myUsername; Password=myPassword
In order to connect to a SQL Server named instance, you must have MDAC 2.6 (or greater) installed.
To Connect to SQL Server via an IP Address:
Provider=SQLOLEDB.1; Data Source=xxx.xxx.xxx.xxx; Initial Catalog=myDatabaseName; User ID=myUsername; Password=myPassword
When Configuration for this Block is Complete:
•Click the Update button to apply the settings.