Sun Chili!Soft ASP Sun Chili!Soft
ASP Sun Microsystems

 

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 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. For Oracle Parameters (without Client), see below.

Parameter

Explanation

DSN*

This is the name of the data source name (DSN) you are configuring.

Description*

This field provides a description of the DSN to help distinguish it from others.

Database type

This 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). It 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. 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:

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

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:

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

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

When this option is enabled (the check box is selected), Oracle returns record sets from a StoredProcedure call. This parameter is enabled by default.

* Required parameters

Oracle Parameters (without Client)

The following table describes the Oracle 8i (8.1.6 and 8.1.7) and 9i database parameters (without client) available for configuring system DSNs, as they appear on the Sun 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

DSN*

This is the name of the data source name (DSN) you are configuring.

Description*

This field provides a description of the DSN to help distinguish it from others.

Database type

This 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). It 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. It is a configurable field.

HostName

This is the 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

This is the port on which the database server is configured to listen. Ask your database administrator for this information.

SID

This is the 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

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:

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

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:

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

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

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

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

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

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.

* Required parameters

See also:

Configuring a Database in this chapter

Configuring Database Parameters in this chapter

Copyright 2002 Sun Microsystems, Inc. All rights reserved. Legal Notice.