Editing a Connection

Follow the steps below to edit the database connection properties:

  1. In the Object Browser pane, right-click the selected connection name and select Edit Connection.

    Editing an active connection will require closing the connection and then reopening the connection with the new properties. A warning message about connections being reset is shown.

    The Edit Connection dialog box is displayed.

  2. Click OK to proceed or Cancel to exit the operation.

    The Connection Name field cannot be modified.

  3. Edit the connection parameters. Connection parameters are explained in Adding a Connection.
  4. Click OK to save the updated connection information.

    • You can click Clear to clear all fields in the Edit Database Connection dialog box.
    • If you click OK without modifying any of the connection parameters, a dialog is displayed indicating that no changes is saved. After a connection parameter is changed the dialog message is displayed.
    • Data Studio allows you to login even if the password has expired with a message informing that some operations may not work as expected. Refer to Password Expiry for information to change this behavior.
    • Refer to Cancel Connection section to cancel the connection.

    If SSL is not enabled, then a Connection Security Alert dialog box is displayed.

  5. Click Continue to proceed with unsecured connection or click Cancel to return to the Edit Connection dialog to enable SSL.

    Do not show again option is used to hide the Connection Security Alert dialog box for subsequent connections.

    The Remove Server Confirmation is displayed to confirm closing databases for the edited connection.

  6. Click Yes to proceed to updating the connection information and reconnecting the connection with the updated parameters.

    The status bar displays the status of the completed operation.