image\cslogo3d1.gif

Configuring a Database

Chili!Soft ASP enables ASP developers to connect with several types of databases from within an ASP application. It provides the built-in ADO Connection object that developers can use to initiate a database connection, along with a set of ODBC drivers that enable that the ASP Server and ODBC Manager to establish and maintain the connection. (For more information about creating and initializing ADO database connections from within an ASP application, see "Connecting to a Database" in "Chapter 4: Building a Chili!Soft ASP Application." )

Chili!Soft ASP automatically installs the needed ODBC drivers for the supported databases. However, for some types of databases, the system administrator must take additional steps to configure the ASP Server. For example, the system administrator must configure SequeLink in order to enable connections from an ASP Server running on a UNIX or Linux system to a Microsoft Access and Microsoft SQL Server 6.5 database running on a Windows system. In addition, the system administrator might want to create system DSNs to make it easier for developers to connect with databases. This section describes how to create and edit DSNs and how to configure the ASP Server to connect with supported databases.

Note

Chili!Soft ASP 3.6 installs the ODBC drivers for a number of databases, but it does not provide them for all databases on all platforms. You can view the list of installed drivers for your platform from the Administration Console, as described in "Viewing the List of ODBC Drivers" in this chapter. Chili!Soft provides technical support only for the ODBC drivers installed with Chili!Soft ASP.

In this section:

·   Configuring Data Source Names (DSNs)

·   Viewing the List of ODBC Drivers

·   Configuring SequeLink

·   Configuring DB2

·   Editing the Microsoft SQL Server Template

·   Configuring the Database Environment

·   Configuring Database Parameters

See also:

Creating Database Connections on the Server in "Chapter 2: Installing and Configuring Chili!Soft ASP"

Copyright 2001 Sun Microsystems, Inc. All rights reserved. Legal Notice.