Modifying Connections in the Data Explorer

Go Up to How To Perform Database Procedures

You can modify connections in a variety of ways from the Data Explorer.

To modify connections

1. Choose View > Data Explorer.
2. Select a provider.
3. Right-click to display a pop-up menu to view your options.

To refresh a connection

1. Choose View > Data Explorer.
2. Select a provider.
3. Right-click to display a pop-up menu.
4. Choose Refresh. This operation reinitializes all connections defined for the selected provider.

To delete a connection

1. Choose View > Data Explorer.
2. Select a connection.
3. Right-click to display a pop-up menu.
4. Choose Delete Connection. This displays a confirmation message that asks if you want to delete the connection.
5. Click OK.

To modify a connection

1. Choose View > Data Explorer.
2. Select a connection.
3. Right-click to display a pop-up menu.
4. Choose Modify Connection. This displays the Connections Editor dialog.
5. Make changes to the appropriate values in the editor.
6. Click OK.

To close a connection

1. Choose View > Data Explorer.
2. Select a connection.
3. Right-click to display a pop-up menu.
4. Choose Close Connection. If the connection is open, this operation closes it.

   Note: If the Close Connection command is disabled in the menu, the connection is not open.

To rename a connection

1. Choose View > Data Explorer.
2. Select a connection.
3. Right-click to display a pop-up menu.
4. Choose Rename Connection. This displays Rename Connection dialog.
5. Enter a new name.
6. Click OK. The Data Explorer displays the connection with its new name.

See Also

• Browsing a Database in the Data Explorer
• Executing SQL in the Data Explorer
• Adding a New Connection to the Data Explorer