Editing a database connection

You can edit a database connection to modify the settings that are used to connect.

About this task

You can edit individual database connections, or you can set preferences for database connections to set global defaults for new or automatic database connections.

Procedure

To edit a database connection:

  1. In the Data Source Explorer (or the Administration Explorer for products that contain this view), right-click on the database connection that you want to edit, and select Properties.
  2. Modify the connection and filter information in the Properties window, and then click OK to save your changes.
    Limitations:
    • For certain databases, including DB2 databases, the Default Schema field is not supported and specifying a value does not set a global default for your database connections.
    • In the Properties tab of the Edit Driver Definitions dialog box at Driver Properties > Edit Driver Definition button (Edit Driver Definition) > Properties, you cannot edit and save the changes that you make to property values. You can manually edit the Value fields but the changes that you make are not saved nor persisted in the Properties dialog box of a database connection profile.

      To modify a driver definition and change the default settings for new connection profiles, you must use the Driver Definitions preference page, see Driver definition preferences.

Results

The connection is modified.

Feedback