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 needing to specify the complete set of information in each string.
You can access DSN configuration settings on the Data Source Names tab of the 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, as well as removing, editing, and testing an existing DSN.
Note
To protect the security of your database, in a shared Web hosting environment, you might prefer developers use DSN-less connection strings or file DSNs in place of system DSNs. For a discussion of these security issues, see "Enabling Database Connections on the Server" in "Chapter 2: Installing and Configuring Chili!Soft ASP."
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 might need to take additional steps to configure the ASP Server to support a particular database. For more information, see "Configuring a Database" in this chapter.
In this section:
Copyright 2001 Sun Microsystems, Inc. All rights reserved. Legal Notice.