Configuring a Database

Sun 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 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 Sun Chili!Soft ASP Application." )

For UNIX and Linux versions of Sun Chili!Soft ASP, the setup program automatically installs the ODBC drivers for a number of databases (ODBC drivers are not installed with Sun Chili!Soft ASP for Windows). 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 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

You can view the list of installed drivers from the Administration Console, as described in "Viewing the List of ODBC Drivers" in this chapter. Sun Chili!Soft provides customer support only for ODBC drivers that are installed with Sun Chili!Soft ASP.

In this section:

· Configuring Data Source Names (DSNs)

· Viewing the List of ODBC Drivers

· Configuring SequeLink

· Configuring the Database Environment

· Configuring Database Parameters