To make it easier for developers to connect an ASP application to a database, the system administrator can add a system data source name (DSN) to the ASP Server. DSNs store information about a database that the ASP Server and ODBC Manager use for connecting to it. Developers can use the system DSN in connection strings on ASP pages to incorporate database information by reference, rather than specifying the complete set of information in each string.
You can access DSN configuration settings on the Data Source Names tab of the Sun Chili!Soft ASP Administration Console Databases page. This tab displays the list of system DSNs that are currently configured for the ASP Server. It also provides access to settings for adding a new DSN to the ASP Server, and for removing, editing, and testing an existing DSN.
To protect the security of your database, in a shared Web hosting environment, you might prefer that developers use DSN-less connection strings or file DSNs instead of system DSNs. For a discussion of these security issues, see "Enabling Database Connections on the Server" in "Chapter 2: Installing and Configuring Sun Chili!Soft ASP."
For Windows systems, DSNs are created and managed from the Windows Control Panel. See Microsoft documentation for more information about using the Windows ODBC Data Source Administrator.
The topics in this section describe how to add, remove, edit, and test system DSNs. In addition to the steps described in this section, you also might need to take other steps to configure the ASP Server to support a particular database. For more information, see "Configuring a Database" in this chapter.
In this section:
· Adding a DSN
· Removing a DSN
· Editing a DSN
· Testing a DSN
Copyright 2002 Sun Microsystems, Inc. All rights reserved. Legal Notice.