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.
|
HostName
|
Computer on which the Oracle server resides. If your network supports named servers, you can specify a host name (such as Oracleserver). Otherwise, specify an IP address.
|
PortNumber
|
Port on which the database server is configured to listen. Ask your database administrator for this information.
|
SID
|
Oracle System Identifier that refers to the instance of Oracle running on the server. You must provide this information when connecting to servers that support more than one instance of an Oracle database.
|
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 StoredProcedure 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.
|
CatalogOptions
|
CatalogOptions 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), the result column REMARKS for the catalog functions SQLTables and SQLColumns, and the result column COLUMN_DEF for the catalog function SQLColumns, will have meaning for Oracle. Enabling this option reduces the performance of your queries. This option is disabled by default, which returns SQL_NULL_DATA for the result columns COLUMN_DEF and REMARKS.
|
EnableStaticCursorsForLongData
|
EnableStaticCursorsForLongData 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), the driver supports long columns when using a static cursor. Enabling this option causes a performance penalty at the time of execution when reading long data. This option is disabled by default.
|
ApplicationUsingThreads
|
ApplicationUsingThreads 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), the driver works with multi-threaded applications. When enabled, the driver is thread-safe. This option is enabled by default.
|