Configuring Database Parameters

To make it easier for Web developers to connect to a database from an ASP page, you can "add" a system DSN for the database to the ASP Server, as described in "Adding a DSN" in this chapter. When you do this, Sun Chili!Soft ASP automatically configures the appropriate parameters for the ODBC driver installed for that database. The ASP Server and ODBC Manager use this information to establish the connection.

In most cases, you should not change the parameters that Sun Chili!Soft ASP configures. However, there might be times when you need to edit them. This topic provides reference information about the parameters that are configured for the ODBC drivers installed by Sun Chili!Soft ASP.

Note

Sun Chili!Soft ASP for UNIX and Linux installs the ODBC drivers for a number of databases (ODBC drivers are not installed with Sun Chili!Soft ASP for Windows). 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 support only for ODBC drivers that are installed with Sun Chili!Soft ASP.

In this section:

· DB2

· dBASE 5

· Informix (with and without client)

· Microsoft SQL Server

· MySQL

· Oracle (with and without client)

· PostgreSQL

· SequeLink (for connecting to Microsoft Access and Microsoft SQL Server 6.5 databases)

· Sybase

· Text