-->
![Oracle Oracle](/uploads/1/2/6/5/126526606/199724679.jpg)
- Oracle Odbc Driver Configuration Fetch Buffer Size 10
- Informatica Oracle Odbc Driver Configuration
- Oracle Odbc Driver Configuration Fetch Buffer Size
The ODBC for Oracle Setup dialog box contains the following controls:
Oracle Odbc Driver Configuration Fetch Buffer Size 10
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 documentation.) |
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 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).
Driver_Name* Driver name to identify the Oracle ODBC driver resides in current Oracle Instant Client home. Default name is “Oracle 12c ODBC driver” for Oracle 12c Instant Client DSN* Sets ODBC DSN name. 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.
Informatica Oracle Odbc Driver Configuration
![Oracle Oracle](/uploads/1/2/6/5/126526606/199724679.jpg)
Oracle Odbc Driver Configuration Fetch Buffer Size
In the ‘User DSN’ tab of the ‘ODBC Data Source Administrator’ dialog, click Add. In the ‘Create New Data Source’ dialog, select the ‘Oracle in OraClient 11g_home1’ driver. Click ‘Finish’. In the ‘Oracle ODBC Driver Configuration’ dialog, enter the details of your data source.