Share via


Using SQLConfigDatasource with the ODBC Driver for Oracle

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.

The following table lists valid SQLConfigDatasource settings for the Microsoft ODBC Driver for Oracle, version 1.0 (Msorcl10.dll) and the Microsoft ODBC Driver for Oracle, version 2.0 (Msorcl32.dll).

Note

The Msorcl10.dll driver (version 1.0) supports all settings except Server. The Msorcl32.dll driver (version 2.0 and higher) supports all settings.

Some settings are ignored by the driver but are accepted by SQLConfigDatasource. Including these settings in the ODBC connection string is the only way they will be accepted at run time. An ignored setting will not be stored in the registry when SQLConfigDatasource creates the data source.

In the following table, A/N means any valid alphanumeric string up to the maximum allowable length. Max Len (maximum length) is the maximum allowable string length accepted by the setting, including the string-terminator character.

Setting Max Len Default value Valid values Description
BufferSize 7 65535 1000 Minimum fetch buffer size up to 65535 bytes
CatalogCap 2 1 0 or 1 If 1, nonquoted identifiers will be converted to uppercase in the catalog functions.
ConnectString 128 "" A/N Connection string. Required method of specifying the server name with the Msorcl10.dll driver.
Description 256 "" A/N Description.
DSN 33 "" A/N Data source name.
GuessTheColDef 4 0 A/N Returns a non-zero value for columns without Oracle-defined scale.
NumberFloat 2 "" 0 or 1 If 0, FLOAT columns are treated as SQL_FLOAT. If 1, FLOAT columns are treated as SQL_DOUBLE.
PWD 30 "" A/N Password.
RDOSupport 2 "" 0 or 1 Allows RDO to call Oracle procedures.
Remarks 2 0 0 or 1 Include REMARKS in catalog functions.
RowLimit 4 "" 0 to 99 Maximum number of rows returned by a SELECT statement. A zero-length string indicates that no limit is applied.
Server 128 "" A/N Oracle server name.
SynonymColumns 2 1 0 or 1 Include SYNONYMs in SQLColumns.
SystemTable 2 "" 0 or 1 If 0, system tables will not be displayed. If 1, system tables will be displayed.
TranslationDLL 33 "" A/N Translation .dll name.
TranslationName 33 "" A/N Translation name.
TranslationOption 33 "" A/N Translation option.
TxnCap 2 "" A/N Transaction capable. If 0, the driver reports that it does not support transactions. If 1, the driver reports that it is capable of performing transactions.
UID 30 "" A/N User name.