Connection List tab

Restriction: This topic applies to Windows environments only.
Connection List
A list of all available connections.
Name
The data source name you specified for the connection when you created it.
Type
The type of database connection, SQL Server or DB2.
ODBC Provider
The ODBC provider to be used for the SQL Server. You can select from a drop-down list of installed and supported SQL Server ODBC providers. The connection is updated to use the selected provider.
Status
The last known status of the connection:
Checking HCOSS is checking the status of the connection
OK Able to connect
error-message

Unable to make the connection using the supplied information. Each connection type provides detailed information as to why the connection test failed.

Unknown Shows for newly created or imported connections when your HCOSS Automatically Test Connections option is set to False, and before you Refresh the connection for the first time
New DB2 Connection
Switch to the DB2 Connection tab to create a new DB2 connection.
New SQL Server Connection
Switch to the SQL Server Connection tab to create a new SQL Server connection.
Edit
Switch to the SQL Server Connection or DB2 Connection tab, depending on the selected connection, where you can make changes to your connection specifications.
Remove
Remove the selected connection.
Repair
Repair a connection that reports a status other than OK or Unknown for at least one connection type. SQL Server connections indicate status for 32- or 64-bit ODBC and 32- or 64-bit CLR 2 or 4 ADO.NET connection types. DB2 connections indicate status for 32- or 64-bit CLR 2 or 4 ADO.NET connection types in the Status column on the Connection List.
Refresh
Update information in the Status column for the selected connection.
Refresh All
Update the information in the Status column for all connections.
System
Create a system connection, and show only system connections on the Connections List grid.
User
Create a user connection, and show only user connections on the Connections List grid.
Set
Displays a dialog box with a drop-down list of installed and supported ODBC providers for SQL Server. All SQL Server connections are updated to the use the selected provider. Affects System or User SQL Server connections.
Encrypt ADO Connection Settings
In this version of HCOSS, this check box has no effect on the connection.