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.
|