ONE Active Server Pages Product Home Page Developer Site Version


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.

Note icon Note For Microsoft Access and Microsoft SQL Server 6.5, Sun ONE ASP includes an ODBC driver for Microsoft SQL Server 7.0 and 2000, but you must use SequeLink 5.3 for connecting to Microsoft Access and Microsoft SQL Server 6.5 databases. You can create a DSN for SequeLink using the following procedure for adding a system DSN.
   For Oracle and Informix (with client), after adding a DSN, you must also define database environment variables, as described in Configuring the Database Environment. Unless the environment variables have been previously set, after you finish adding a new DSN, the Sun ONE ASP Administration Console displays the appropriate page on which to configure these settings.

To add a system DSN

  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, click Add new DSN in the bottom left of the screen.

  4. The New Data Source Name page displays.

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

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

  7. 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).

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

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

  10. - 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.

Note icon Note For Windows systems, data source names are created and managed from the Windows Control Panel. See Microsoft documentation for more information.

See also:

Configuring Data Source Names (DSNs)

Removing a DSN

Editing a DSN

Creating Database Connections (ASP Server)

Add/Edit DSNs (CLI)