ONE Active Server Pages Product Home Page Developer Site Version


Editing a DSN

After adding a system DSN to the ASP Server you can change its information, such as name, description, IP address, username, and password. You can also add values for parameters that were not configured when you added the DSN.

When you add a new DSN to the ASP Server, Sun ONE Active Server Pages automatically sets the correct parameters for the database. Changing these parameters can affect database performance, and is not recommended; the default settings are sufficient for most applications. Before editing database parameters, see the descriptions of required parameters for each ODBC driver in Configuring Database Parameters.

To edit system DSN information

  1. Open the Administration Console (see Accessing the Administration Console).

  2. On the ASP Server tab of the Server Management page, click Databases.

  3. On the Databases page, in line with the DSN you want to edit, click edit.

  4. The Edit Data Source Name page displays.

  5. Edit the information as desired.

  6. To save your changes, click Save and then click Done.

  7. - or -

    Click Cancel to revert to the settings that were last saved.

See also:

Configuring Data Source Names (DSNs)

Adding a DSN

Removing a DSN

Testing a DSN

Add/Edit DSNs (CLI)