To import a connection
- From the HCO for SQL Server interface, click
Manage Connections.
- On the
Import tab, type the full path to and filename of an XML (.xml) file containing the exported connection(s) that you want to import, or click the browse button to select a file.
- Click
Read Available Connections to populate the list.
- Select one or more connections to import. Use
Ctrl+Click to select multiple connections.
- Click
Import.
Note:
- If one or more of the selected connections uses a provider other than the
SQL Native Client, or if you do not have the appropriate database provider installed, the
Import button is disabled and you cannot import the connection.
- When using Azure mode, HCOSS does not support the importation of a DB2 connection. If a DB2 connection is selected, the
Import button is disabled and you cannot import the connection.
- When importing an OleDb Data Provider connection, whenever possible, HCOSS uses the same driver version that was in use when the connection was exported. For example, if the exported connection used SQL Server Native Client 10.0, and that version is installed and available for the import, HCOSS uses it. If the version specified is not installed or is not available, HCOSS uses the latest version available for that driver.
- HCOSS cannot import a connection that has the same name as an existing connection. In this case, HCOSS notifies you that the connection already exists, and does not perform the import of that connection.
- When the import is complete, click
OK to clear the message. You should see the imported connections on the
Connection List found on the
Connection List tab.
