Adding a DSN-based Connection (DBMS)

DSN-based connections can be added by specifying parameters in an HTML form that are then used to construct a connection string, or by entering the entire connection string. Use the following procedure to add a DSN-based connection. Click Cancel at any time to cancel the action.

Open DBMS using the URL provided by your Sun ONE ASP administrator.

Click Add a DSN-based Connection in the left pane.

The Add a DSN-based Connection form displays.

In the Title box, type the title for the connection string. This title represents the connection string and will be displayed in the DBMS interface.

In the Description box, type a description of the connection to help distinguish it from others.

Provide connection information. Either:

Use the form to provide connection information, as described in the remaining steps.

- or -

Enter the entire connection string directly in the Connection string box, and then go to step 9.

In the DSN box, type the name of the DSN.

In the Username box, type the username to be used for accessing the database.

In the Password box, type the password to be used for accessing the database.

To preview the connection string before using it to connect to the database, click Preview.

A connection string is generated and displayed in the Connection string box.

To establish a connection using the connection string, click Submit. The connection will either succeed or fail:

If the string information is correct, a database connection is established, and the connection is displayed in the left pane in the DBMS interface.

If the string information is incorrect, the connection will fail, and you will be advised of the error.

You can do one of the following:

Try to connect again by making changes in the form and then clicking Retry.

- or -

Save the connection string anyway by clicking Save Anyway. The inactive connection will be saved and displayed in the DBMS interface with a red X, indicating a connection cannot be established with the parameters provided.

Changes to the connection string can be made at a later time, as described in Editing a DSN-based Connection (DBMS).