You are here: Configuring a Database

Configuring a Database

Sun ONE Active Server Pages 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.)

For UNIX and Linux versions of Sun ONE ASP, the setup program automatically installs the ODBC drivers for a number of databases (ODBC drivers are not installed with Sun ONE ASP for Windows). You can view the list of installed drivers from the Sun ONE ASP Administration Console, as described in Viewing the List of ODBC Drivers (customer support is provided only for ODBC drivers that are installed with Sun ONE ASP). For some types of databases, however, 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 (see Configuring SequeLink). 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.

In this section:

Viewing the List of ODBC Drivers

Configuring Data Source Names (DSNs)

Configuring the Database Environment

Configuring Database Parameters

Configuring ADO Connections