The following table describes the Oracle 7,8,8i database parameters available for configuring system DSNs, as they appear on the Chili!Soft ASP Administration Console New Data Source Name and Edit Data Source Name pages. For more information, see "Configuring Data Source Names (DSNs)" in this chapter.
Parameter |
Explanation |
Data Source Name* |
This is the name of the data source name (DSN) you are configuring. |
Database type |
This indicates for which type of database you are configuring this DSN (Oracle 7, 8, or 8i). |
Description* |
This field provides a description of the DSN to help distinguish it from others. |
Driver* |
On the New Data Source Name page, this is the name of the ODBC driver installed for the type of database selected in the Database type box (Oracle 7, 8, or 8i). It is a non-configurable field. On the Edit Data Source Name page, this is the absolute path name of the ODBC driver specified for this DSN. It is a configurable field. |
ServerName* |
This is the TNS name as defined in the tnsnames.ora file by the Oracle database client utility. |
LogonID |
This is the username required for accessing the database. If the username is not provided when configuring a system DSN, every connection string using this DSN must include the username. Important Security Note: In shared Web hosting environments, to prevent access to a database by unauthorized users, it is recommended that the username and password be provided in each connection string, rather than in the system DSN. |
Password |
This is the password required for accessing the database. If the password is not provided when configuring a system DSN, every connection string using the DSN must include the password. Important Security Note: In shared Web hosting environments, to prevent access to a database by unauthorized users, it is recommended that the username and password be provided in each connection string, rather than in the system DSN. |
EnableDescribeParam |
When this option is enabled (the checkbox is selected), all StoredProcedure arguments are returned as string types. Enabled by default. |
ProcedureRetResults |
When this option is enabled (the checkbox is selected), Oracle returns record sets from a StoredProcedure call. Enabled by default. |
* Required parameters.
See also:
Configuring a Database in this chapter
Configuring Database Parameters in this chapter
Copyright 2001 Sun Microsystems, Inc. All rights reserved. Legal Notice.