Update a Query Connection
The following article is a brief overview on updating query connections.
Update All Connections
The Update All Connections panel is used to make mass revisions to the original connection assigned to queries, to a new connection.
- From the Spreadsheet Server Ribbon, select Tools > Update All Query Connections. The Update All Connections panel appears.
- Use the following table to enter data in the Update All Connections panel:
- Click OK. The system updates the appropriate queries, replacing the original connection with the new connection.
Field |
Description |
|---|---|
Using the Connection |
From the list of connections associated with existing queries, select the connection to be updated. The system displays the original connection in the associated drop-down list. |
Will now be updated to use the Connection |
From the list of connections available for use in Query Designer, select the connection to be assigned to the queries associated with the original connection. The system displays the available connection in the associated drop-down list. Note: The list excludes SQL Server connections flagged as load local connections. |
Update Connections by File
The Update Connections by File panel is used to make a revision to the original connection of a file assigned to the query, to a new connection.
- From the Spreadsheet Server Ribbon, select Tools > Update Connections by File. The Update Connections by File panel appears.
To update a connection, select the file(s) to be updated, then, from the New Connection drop-down list, select the connection to be assigned to the queries associated with the original connection.
Click Update. The system updates the appropriate files, replacing the original connection with the new connection.