Create, Amend and Delete ODBC actions. An action could be triggered when a user opens a particular application, enabling access to a database containing relevant data.
ODBC connections enable a computer to access data from any application, regardless of the database management system (DBMS). Use this action to establish a connection between a computer and a database stored on another system. The following actions are available:
- Create ODBC Connection
- Amend ODBC Connection
- Delete ODBC Connection
To specify an ODBC connection for any of the three actions select the Connection Details tab and complete the following fields:
|Connection Name||A unique name to identify the connection.|
|Driver Type||A drop down list containing the available driver types|
|Current Connections||The list is automatically populated with all available connections on the current computer, based on the driver type selected.|
Once the connection is defined, specific programs can be told to use the connection to access information on that database.