4.5 Database Configuration

Database configuration can be reached from the Properties page for an ASP Server by clicking on the `Databases' link.
4.5.1.1 Data Source Names (DSNs)
Data Source Names (DSNs) are a "friendly" name for a potential database connection. Rather than needing to specify the driver, port, and database for each connection, it can be referred to symbolically by its DSN. DSNs allow you to define a connection to a database so that subsequent database connections from ASP can be created using the DSN instead of a full connection string (that would have to specify the driver, port, database, userid, password, etc).
This tab shows all DSNs for the ASP Server. Each listing shows the DSN name and the associated database driver. There are also links for `Add New DSN', `Remove (DSN)', and `Edit (DSN)'. These links are discussed below. Check the Database Parameters
section for more information on what information will be required to configure each DSN.
Remove a DSN
Remove the DSN so that the symbolic name no longer can be used.
Add a New DSN
This page allows you to add new DSNs (Data Source Names). Select the driver that you wish to use and click "Next". You will be prompted for information specific to each driver type. Check the sections on Database Parameters
below for more information on the parameters required for each supported ODBC driver.
Edit a DSN
Each DSN has additional configuration parameters. With this link, you can change the parameters that you set during "Add New DSN". Changing these parameters can affect database performance. The parameters are dependent on which driver is assigned to the DSN. Check the sections on Database Parameters below for more information on the parameters required for each supported ODBC driver.
Configuring SequeLink
SequeLink can be thought of as a distributed ODBC driver. The SequeLink "client" resides on the same machine as Chili!Soft ASP and looks like an ODBC driver. It communicates to a SequeLink "server" that resides on a remote machine. With Chili!Soft ASP the remote machine can be NT or Solaris. Each DSN using the SequeLink ODBC client must be assigned to a SqlnkDSN. Instructions for creating these links to remote databases can be found in Chapter 3: Configuration, under the sections on "Microsoft Access Setup" or "Microsoft SQL Server Setup".
4.5.1.2 Drivers
The `Drivers' tab provides information on all ODBC drivers that Chili!Soft ASP ships with. Check here to find out if a specific version of a database is supported.
4.5.1.3 ADO Settings
ADO (Active-X Data Objects) is the Microsoft standard for database access. This tab provides access to Connection Pooling settings for Chili!Soft's ADO component. Setting the "Connection pool size" to 0 (zero) disables connection pooling. The default is 25, and may be increased or decreased. If you provide a file name and path in the "Logging file" textfield, logging will be enabled and Chili!Soft ASP will write log entries to the file specified.
4.5.1.4 Environment
Several database servers require additional environment information. You only need to provide this information for Oracle, Sybase and Informix databases. Refer to the `Environment' tab for a listing of the required environment settings for each of these databases. If you are uncertain of what information needs to go in these fields, contact your database administrator.
Copyright © 2000 Chili!Soft
|