Adding a DSN

Use the following procedure to add a system DSN to the ASP Server. When a DSN is added, Sun ONE Active Server Pages automatically sets the correct parameters for the databases. You can edit these parameters if necessary, as described in Editing a DSN.

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

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

On the Databases page, click Add new DSN in the bottom left of the screen.

The New Data Source Name page displays.

In the DSN box, type a name for the DSN.

In the Description box, type a description of the DSN to help distinguish it from other DSNs.

In the Database type drop-down list, select the type of database for which you want to configure a DSN (for Microsoft Access and Microsoft SQL Server 6.5 databases, select SequeLink 5.3).

In the remaining text boxes, provide the requested information (if necessary, see the information specific to your database in Configuring Database Parameters).

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

- or -

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

The new DSN displays in the Data Source Names list. After adding a DSN, you should also test it, as described in Testing a DSN.