Setting SQL Connections

AutoMate allows you to globally create user defined SQL connection strings which can be used in actions that require a SQL connection.

To add a SQL connection:

  1. From the System menu in the Task Administrator window, select Options.

  2. Click the SQL Connections tab. A dialog box appears as shown below:

  1. Click the Add button. A dialog titled AutoMate Connection Strings appears as shown below.

  1. Enter the values for the following:

    1. SQL connection name: The name of the SQL connection. This is how the SQL connection is referred to in AutoMate tasks and scripts.

    2. SQL connection value: Specifies the SQL connection string.  

    3. SQL connection comment: A description for the SQL connection. This is used only in the User Defined SQL Connections view as reference and has no bearing on the SQL connection itself.

  2. You can disable the connection string by clearing the Enable check box (this option is enabled by default). When finished, click the OK button. The new connection then appears in the list of user defined SQL connections.  

  3. Click OK to save changes and close the dialog box.

To Remove an existing SQL connection:

  1. Select the SQL connection from the list of user defined SQL connections.

  2. Click the Remove button.

To modify an existing SQL connection:

  1. Select the SQL connection from the list of user defined SQL connections.

  2. Click the Modify button. A dialog titled AutoMate Connection Strings appears.

  3. Edit the values of the SQL connection name, value and description entered in the appropriate fields. Additionally, you can disable the connection string by un-checking the Enable checkbox (this option is enabled by default).

  4. When finished, click the OK button. The modified values then appear in the list of user defined SQL connections.  

See Also

Configuring AutoMate

SQL_Connections