image\cslogo3d1.gif

Configuring Database Parameters

In order 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, Chili!Soft ASP automatically configures the appropriate parameters for the ODBC driver installed for that database. The ASP Server and ODBC Manager then use this information to establish the connection.

In most cases, it is not a good idea to change the parameters that Chili!Soft ASP configures. However, there might be times when you must edit them. This topic provides reference information about the parameters that are configured for the ODBC drivers installed by Chili!Soft ASP 3.6.

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:

·   DB2

·   dBase 5

·   Informix 7, 9

·   Interbase 6 (Linux and Cobalt only)

·   Microsoft SQL Server 7.0

·   MySQL 3.22.32 (Linux, Cobalt, and Solaris only)

·   Oracle 7, 8, 8i (versions 8 and 8i on Linux and Cobalt only)

·   PostgreSQL 6.5.2 (Linux and Cobalt only)

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

·   Sybase 11.9.2

See also:

Configuring a Database in this chapter

Editing a DSN in this chapter

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