Search notes:

OraOLEDB specific connection string attributes

The following table summarizes OraOLEDB specific connection string attributes.
Some of (default) values of these attributes can be overwritten in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_homename\OLEDB.
CacheType Type of cache used to store the rowset data on the client. Possible values: Memory or File
ChunkSize Size of LONG or LONG RAW column data stored in the provider's cache. The range of allowed values is 1 … 65536, the default is 100.
DistribTX enable or disables distributed transaction enlistment capability. Possible values: 0 and 1 (1 being the default)
FetchSize number of rows that will be fetched at a time. Possible values seem to be 1 … 496 (?), default seems to be 100.
OLEDB.NET enables or disables compatibility with OLEDB.NET Data Provider. Values: True or False
OSAuthent whether operating system authentication will be used when connecting to an Oracle Database. Values: 0 or 1, default being 1
PLSQLRSet enable or disables the return of a rowset from PL/SQL stored procedures.
PwdChgDlg enable or disables displaying the password change dialog box when the password expires.
UseSessionFormat specifies whether to use the default NLS session formats or let OraOLEDB override some of these formats for the duration of the session. Possible values: 0 (default) and 1 (TRUE). This attribute does not appear under HKLM\SOFTWARE\ORACLE\KEY_HOMENAME\OLEDB.
VCharNull enables or disables the NULL termination of varchar2 out parameters from stored procedures.
SPPrmDefVal specifies whether to use the default value or a NULL value if the application has not specified a stored procedure parameter value.
NDataType whether any of the parameters bound to the command are of N data types, which include nchar, nvarchar2 or nclob. This attribute does not appear under HKLM\SOFTWARE\ORACLE\KEY_HOMENAME\OLEDB.
SPPrmsLOB whether one or more parameters bound to the stored procedures are of LOB data type. This attribute does not appear under HKLM\SOFTWARE\ORACLE\KEY_HOMENAME\OLEDB.
StmtCacheSize specifies the maximum number of statements that can be cached.
MetaDataCacheSize the maximum number of select statements for which the metadata can be cached. Possible values are 0 … 10 (default: 10)
DeferUpdChk whether or not to defer the updateability check to support updating read-only disconnected rowsets. Possible values are 0 and 1
DBNotifications whether or not to subscribe to the high availability events.
DBNotificationPort port number which is opened to listen to the Database notifications. (Enhanced Failover Capability)

Index