Microsoft ODBC for Oracle Setup Dialog Box

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.
Description Contains any descriptive qualifiers; blank by default.
User Name The user name for the data source.
Server 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 help file.)
Translation Click Select to choose a loaded data translator; defaults to No Translator.
Performance 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).

Customization 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.


Note   Detailed and programmatic information about this driver is located at msdn.microsoft.com. (Open the MSDN Library Online and then the Platform SDK to find the MDAC SDK, which contains a section called 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 in this help file.