The ODBC for Oracle Setup dialog box contains the following controls:

Data Source Name

The name or identifier used by applications to call or use this data source. Users can use any descriptive method to name a data source. This field is blank by default, but required.


Contains any descriptive qualifiers; blank by default.

User Name

The user name for the data source.


The database alias created in SQL*Net Easy Configuration or a connect string. (For information about string construction, see Connection String Attributes. For descriptions of personal and remote database connect strings, see the Oracle documentation.)


Click Select to choose a loaded data translator; defaults to No Translator.


Buffer Size specifies the size, in bytes, allocated to receive fetched data. The driver optimizes fetching so that one fetch from the Oracle Server returns enough rows to fill a buffer of the specified size. Larger values tend to increase performance when fetching a lot of data.

Include REMARKS in Catalog Functions specifies that the driver should return Remarks columns for the SQLColumns result set. Clear this option for faster performance.

Include SYNONYMS in SQL Columns specifies that, when set to True (1), a SQLColumns() API call returns column information for Tables, Views, and Synonyms. This driver retrieves column information faster when this value is not set (or when the value is set to 0).


Enforce ODBC DayOfWeek Standard sets the result set to a particular day-of-week format. If selected, specifies that the result set conforms to the ODBC day-of-week format (Sunday = 1; Saturday = 7). Otherwise, conforms to the Oracle day-of-week format (Monday = 1; Sunday = 7).

SQLDescribeCol always returns a value for precision specifies that the SQLDescribeCol call will return 130 for the precision when Oracle does not provide that information. Some Oracle numeric data types do not have a fixed precision, such as computed numeric columns and columns defined as NUMBER without a precision or scale. If this check box is cleared, the driver will return 0 for these types of columns.

Detailed and programmatic information about this driver is located in the MSDN Library, in ODBC Drivers. The Microsoft ODBC Driver for Oracle supports only SQL*Net 2.3 or later. For more information about Oracle products, refer to your Oracle documentation. Other information can be found under Software Support Levels and Product Support (Oracle Driver).