Oracle Parameters (With Client)

The following table describes the Oracle 7 and 8.05 (with client) database parameters available for configuring system DSNs, as they appear on the Sun ONE ASP Administration Console New Data Source Name and Edit Data Source Name pages. For more information, see Configuring Data Source Names (DSNs).


Parameter	Explanation
DSN* Data Source Name*	Name of the data source name (DSN) you are configuring.
Description*	Description of the DSN to help distinguish it from others.
Database type	Indicates for which type of database you are configuring this DSN (Oracle).
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). This is a nonconfigurable field. On the Edit Data Source Name page, this is the absolute path name of the ODBC driver specified for this DSN. This is a configurable field.
ServerName*	TNS name as defined in the tnsnames.ora file by the Oracle database client utility.
LogonID	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. Caution: To prevent access to a database by unauthorized users in shared Web hosting environments, it is recommended that the username and password be provided in each connection string, rather than in the system DSN.
Password	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. Caution: To prevent access to a database by unauthorized users in shared Web hosting environments, it is recommended that the username and password be provided in each connection string, rather than in the system DSN.
EnableDescribeParam	EnableDescribeParam is displayed in the Sun ONE ASP Administration Console only when you are editing an existing DSN, not adding a new one. When this option is enabled (the check box is selected), all StoreProcedure arguments are returned as string types. This parameter is enabled by default.
ProcedureRetResults	ProcedureRetResults is displayed in the Sun ONE ASP Administration Console only when you are editing an existing DSN, not adding a new one. When this option is enabled (the check box is selected), Oracle returns record sets from a StoredProcedure call. This parameter is enabled by default.