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:
|A unique name to identify the connection.
|A drop down list containing the available driver types
|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.