The features on this page require a GENESIS64 Advanced license and are not available with GENESIS64 Basic SCADA . |
This topic is a continuation of the process described in the Connecting to Open Databases topic. Follow these steps to establish an ODBC database connection.
Note: If you previously created a connection in ReportWorX or BridgeWorX, you can re-use that connection here. |
To Connect to an ODBC Database:
Open the Workbench. Expand your project folder, then the Data Connectivity node, then the Databases node.
Right-click the ODBC Connections node then click on Add ODBC Connection, as shown below.
Add ODBC Connection in Project Explorer
-OR-
Select the ODBC Connections node, then click on the Add ODBC Connection button, shown below, in the Edit section of the Home ribbon in the Workbench.
Add ODBC Connection Button
ODBC Connection Properties
Enter a Description in the text entry field.
In Connection String, you can click on the Configure Connection link, which will open the ODBC Connection String window, similar to the one shown below. Once you have entered the requested info, click OK to return to the connection properties.
Connection String Window
The Test Connection link allows you to check the connection parameters for possible errors.
Enter a Timeout (in seconds) for the ODBC Connection in the text entry field. "0" signifies no timeout.
Click Apply to save your changes and Close to exit from the connection properties.
See Also:
Creating a Database Connection