Oracle Connection String Attribute Table

The defaults listed in the table are initial defaults that apply when no value is specified in either the connection string or in the data source definition in ODBC.INI. If you specified a value for the attribute when configuring the data source, that value is your default.

Attribute Description
DataSourceName (DSN) A string that identifies an Oracle data source configuration in ODBC.INI. Examples include "Accounting" or "Oracle-Serv1."
LogonID (UID) The logon ID (user name) that the application uses to connect to your Oracle database. A logon ID is required only if security is enabled on your database. If so, contact your system administrator to get your logon ID.
Password (PWD) Your password.
LockTimeOut (LTO) A value that specifies whether Oracle should wait for a lock to be freed before raising an error when processing a Select...For Update statement. Values can be -1 (wait forever, the initial default) or 0 (don't wait).
ArraySize (AS) The number of bytes the driver uses for fetching multiple rows. Values can be an integer from 0 to 65536. The initial default is 60000. Larger values increase throughput by reducing the number of times the driver fetches data across the network. Smaller values increase response time, as there is less of a delay waiting for the server to transmit data.
ServerName (SRVR) The SQL*Net connection string designating the server and database to be accessed. The information required varies depending on the SQL*Net driver you are using. For remote servers, the SQL*Net connection string has the following form:
driver_prefix:computer_name[:sid] 

driver_prefix identifies the network protocol being used. The driver prefix can be as follows: P (named pipes), X (SPX), B (NetBIOS), T (TCP/IP), D (DECNet), A (Oracle Async), or TNS (SQL*net 2.0). Check your Oracle documentation for other protocols.

computer_name is the name of the Oracle Listener on your network.

sid is the Oracle System Identifier and refers to the instance of Oracle running on the host. This item is required when connecting to systems that support more than one instance of an Oracle database. For local servers, the SQL*Net connection string has the form:

database_name 

database_name identifies your Oracle database. If the SQL*Net connection string contains semicolons, enclose it in quotation marks. See your SQL*Net documentation for more information.

CatalogComments (CC) CatalogComments={0|1}. This attribute specifies whether the driver returns the contents of the COMMENTS column for catalog functions. CatalogComments=1 returns COMMENTS. Retrieving the COMMENTS column may reduce the performance of your data catalog operations. CatalogComments=0 does not return COMMENTS (the initial default).


Install ODBC Drivers
Connect to Oracle 7 Data Source


ODBC Drivers
Oracle 7 Data Types
Isolation and Locking
ODBC Driver Error Messages