Return to site

Oracle Odbc Driver Configuration Fetch Buffer Size

broken image
Odbc

The release notes provide details of enhancements, features, and known issuesin Simba Oracle ODBC Driver 1.2.9, as well as the version history.

1.2.9

Released 2019-02-08

Figure 21-3 Oracle ODBC Driver Configuration Dialog Box The following list is an explanation of the main setup options and fields found on the Oracle ODBC Driver Configuration dialog box shown in the preceding graphic. The tabs found on the lower half of this dialog box are described in subsequent topics. He set about designing a guitar amplifier around the new principle, and in 1972 the was released. He produced a number of custom variations on the Mark I through the late 1970s, with options including reverb, EQ, various speakers (most often Altec or ElectroVoice), jointed cabinets, and wicker grill. Im using sun.jdbc.odbc.JdbcOdbcDriver to connect to an oracle database.I know I would be probably be better off using the thin driver but I want the app to work without specifying the db server name and port no.My connection string is like jdbc:odbc:DSN.

Enhancements & New Features

Jun 15, 2012 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 11ghome1' driver. Click ‘Finish'. In the ‘Oracle ODBC Driver Configuration' dialog, enter the details of your data source. 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 11ghome1' driver. In the ‘Oracle ODBC Driver Configuration' dialog, enter the details of your data source.

  • [ORCL-464] Disable automatic IPD population

    You can now stop the driver from automatically populating the fields ofthe Implementation Parameter Descriptor (IPD). To do this, enable the newDisable Default Auto IPD (or DisableDefaultAutoIPD) property. For moreinformation, see the Installation and Configuration Guide.

Resolved IssuesThe following issue has been resolved in Simba Oracle ODBC Driver 1.2.9.

  • [ORCL-438] The driver cannot insert more than 1056 rows into an Oracledata store.

Known IssuesThe following are known issues that you may encounter due to limitations inthe data source, the driver, or an application.

  • When converting extremely large values to SQL_FLOAT(9.99999999999999e+125 or greater) the driver might stop responding.

Workflow Changes

The following changes may disrupt workflows from earlier versions.

1.2.7 ————————————————————————

  • 32-bit applications no longer supported on macOS

    Beginning with this release, the driver uses Oracle Instant Client 12.2instead of 12.1. Due to platform support differences in the Oracle InstantClient, the macOS version of the driver no longer supports 32-bitapplications.

  • Oracle Instant Client upgrade

    Beginning with this release, the driver requires Oracle Instant Client 12.2instead of 12.1. If you installed Oracle Instant Client and the driverthrough separate installation processes, then the Oracle Instant Clientdoes not get updated automatically and the driver may not work as expected.

    To resolve this, make sure to upgrade your installation of Oracle InstantClient. For instructions, see the Installation and Configuration Guide.

Version History

Oracle Odbc Driver Configuration Fetch Buffer Size Definition

Install

1.2.8 ———————————————————————— Mail merge toolkit crack.

Released 2018-12-21

Enhancements & New Features

Oracle Odbc Configuration

  • [ORCL-413] Kerberos authentication

    You can now authenticate your connection using the Kerberos protocol. To dothis, enable the new Use External Credentials (or UseExternalCredentials)property. The driver then authenticates the connection using the Kerberossettings configured in your sqlnet.ora configuration file. For moreinformation, see the Installation and Configuration Guide.

  • [ORCL-416] TCPS protocol

    You can now configure the driver to use the TCPS protocol, which enablesyou to encrypt your connections using SSL/TLS when connecting over TCP/IP.To do this, enable the new Use TCPS (or UseTCPS) property. The driver thenencrypts the connection using the SSL settings configured in yoursqlnet.ora configuration file. For more information, see the Installationand Configuration Guide.

  • [ORCL-435] Updated workflow for TNS connections

    When you connect using a connection string or from a non-Windows machine,the TNS Name (or TNS) property now takes precedence over the Host, Port,and Service Name properties (Host, Port, and SVC, respectively).

Install Oracle Odbc Driver

Oracle Odbc Driver Configuration Fetch Buffer Size

1.2.7 ————————————————————————

Released 2018-10-12

Enhancements & New Features

  • [ORCL-308] Upgrade to Oracle Instant Client 12.2

    The driver now uses version 12.2 of the Oracle Instant Client as adependency. Previously, the driver used version 12.1.

    IMPORTANT:
    • Due to platform support differences in the Oracle Instant Client, themacOS version of the driver no longer supports 32-bit applications.
    • If you installed Oracle Instant Client and the driver through separateinstallation processes, then make sure to manually upgrade Oracle InstantClient to version 12.2. For instructions, see the Installation andConfiguration Guide.

Resolved IssuesThe following issue was resolved in Simba Oracle ODBC Driver 1.2.7.

  • [ORCL-433] The TIMESTAMP WITH TIME ZONE data type is not supported.

    This issue has been resolved. The driver is now able to work with theTIMESTAMP WITH TIME ZONE data type from Oracle databases, mapping it tothe SQL_TYPE_TIMESTAMP data type.

1.2.6 ————————————————————————

Released 2018-09-12

Oracle Odbc Driver Configuration Fetch Buffer Size For Mac

Resolved IssuesThe following issues were resolved in Simba Oracle ODBC Driver 1.2.6.

  • [ORCL-259] Error messages produced by the driver are not formattedcorrectly.

  • [ORCL-427] In some cases the driver returns NULL values when reading largeamounts of rows.

1.2.5 ————————————————————————

Released 2018-07-18

Enhancements & New Features

  • [ORCL-381] Error messages enhanced

    When you enter an invalid character or a value outside the acceptablerange for 'Statement Cache Size' or 'Fetch Buffer Size' in the DSN setup,

    the driver now displays an error message that includes more informationabout the values that you entered.

  • [ORCL-348] Updated encryption method for driver on Windows

    The driver now uses the DPAPI encryption method to make sure that thecredentials can only be used by the current user (for User DSNs) or usedby all users on the same machine (for System DSNs). The registry contentscannot be used to create the same user DSN or system DSN on anothercomputer. Also, the user DSN registry contents cannot be used to createa system DSN on the same computer.

1.2.4 ————————————————————————

Microsoft Odbc For Oracle Driver

Released 2018-06-05

Enhancements & New Features

  • [ORCL-375] Updated log file name

    The log file that the driver generates when logging is enabled has beenrenamed from oracle_driver.log to simbaoracleodbcdriver.log.

  • [ORCL-353] Internal Driver Improvements

    The driver has been updated with internal security improvements.

Resolved IssuesThe following issues were resolved in Simba Oracle ODBC Driver 1.2.4.

  • [ORCL-366] Driver displays an incorrect alert for data source namevalidation.

    This issue has been resolved. When adding a DSN through the ODBCAdministrator, if you enter invalid characters in the Data Source Namefield, the driver now displays an alert with the correct message andprevents you from using invalid characters.

  • [ORCL-362] Driver incorrectly handles SQL queries having argumentof zero length.

    This issue has been resolved. When a SQL query with an argument lengthequal to zero is run, the driver now responds with the correct errormessage such as 'Invalid string or buffer length'.

1.2.3 ————————————————————————

Released 2018-04-25

Enhancements & New Features

  • Driver supports statement caching

    You can now cache statements using the driver. Use this feature if youwant to improve driver performance for parsing the same statement multipletimes in the same connection. Make sure that you enable statement cachingonly when required because statement caching requires more memory. For moreinformation, see the Installation and Configuration Guide.

  • Upgrade to OpenSSL 1.1.0h

    The driver now uses OpenSSL 1.1.0h for encryption of data.

  • MEMLIM option available through the user interface

    The MEMLIM configuration option, which was available only as a key name, isnow accessible via the Windows user interface for the driver. Use the FetchBuffer Size field to configure MEMLIM through the user interface. For moreinformation, see the Installation and Configuration Guide.

1.2.2 ————————————————————————

Released 2018-02-28

Enhancements & New Features

  • Support for the Basic Light Oracle Instant Client

    You can now use the Basic Light version of the Oracle Instant Clientpackage. This Basic Light package requires less disk space comparedto the Basic Package.

1.2.1 ————————————————————————

Released 2018-02-09

Resolved IssuesThe following issues were resolved in Simba Oracle ODBC Driver 1.2.1.

  • Under some circumstances the driver calls deprecated OCI functions.

  • During installation the system message 'Error creating temporary swapfile name' may appear.

  • When you link data to your data source in Microsoft Access, an error mayoccur, displaying an error message such as 'Reserved error (-7745); thereis no message for this error.'

1.2.0 ————————————————————————

Released 2017-12-12

Oracle Odbc Driver Configuration Fetch Buffer Size
Odbc driver for oracle

The release notes provide details of enhancements, features, and known issuesin Simba Oracle ODBC Driver 1.2.9, as well as the version history.

1.2.9

Released 2019-02-08

Figure 21-3 Oracle ODBC Driver Configuration Dialog Box The following list is an explanation of the main setup options and fields found on the Oracle ODBC Driver Configuration dialog box shown in the preceding graphic. The tabs found on the lower half of this dialog box are described in subsequent topics. He set about designing a guitar amplifier around the new principle, and in 1972 the was released. He produced a number of custom variations on the Mark I through the late 1970s, with options including reverb, EQ, various speakers (most often Altec or ElectroVoice), jointed cabinets, and wicker grill. Im using sun.jdbc.odbc.JdbcOdbcDriver to connect to an oracle database.I know I would be probably be better off using the thin driver but I want the app to work without specifying the db server name and port no.My connection string is like jdbc:odbc:DSN.

Enhancements & New Features

Jun 15, 2012 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 11ghome1' driver. Click ‘Finish'. In the ‘Oracle ODBC Driver Configuration' dialog, enter the details of your data source. 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 11ghome1' driver. In the ‘Oracle ODBC Driver Configuration' dialog, enter the details of your data source.

  • [ORCL-464] Disable automatic IPD population

    You can now stop the driver from automatically populating the fields ofthe Implementation Parameter Descriptor (IPD). To do this, enable the newDisable Default Auto IPD (or DisableDefaultAutoIPD) property. For moreinformation, see the Installation and Configuration Guide.

Resolved IssuesThe following issue has been resolved in Simba Oracle ODBC Driver 1.2.9.

  • [ORCL-438] The driver cannot insert more than 1056 rows into an Oracledata store.

Known IssuesThe following are known issues that you may encounter due to limitations inthe data source, the driver, or an application.

  • When converting extremely large values to SQL_FLOAT(9.99999999999999e+125 or greater) the driver might stop responding.

Workflow Changes

The following changes may disrupt workflows from earlier versions.

1.2.7 ————————————————————————

  • 32-bit applications no longer supported on macOS

    Beginning with this release, the driver uses Oracle Instant Client 12.2instead of 12.1. Due to platform support differences in the Oracle InstantClient, the macOS version of the driver no longer supports 32-bitapplications.

  • Oracle Instant Client upgrade

    Beginning with this release, the driver requires Oracle Instant Client 12.2instead of 12.1. If you installed Oracle Instant Client and the driverthrough separate installation processes, then the Oracle Instant Clientdoes not get updated automatically and the driver may not work as expected.

    To resolve this, make sure to upgrade your installation of Oracle InstantClient. For instructions, see the Installation and Configuration Guide.

Version History

Oracle Odbc Driver Configuration Fetch Buffer Size Definition

1.2.8 ———————————————————————— Mail merge toolkit crack.

Released 2018-12-21

Enhancements & New Features

Oracle Odbc Configuration

  • [ORCL-413] Kerberos authentication

    You can now authenticate your connection using the Kerberos protocol. To dothis, enable the new Use External Credentials (or UseExternalCredentials)property. The driver then authenticates the connection using the Kerberossettings configured in your sqlnet.ora configuration file. For moreinformation, see the Installation and Configuration Guide.

  • [ORCL-416] TCPS protocol

    You can now configure the driver to use the TCPS protocol, which enablesyou to encrypt your connections using SSL/TLS when connecting over TCP/IP.To do this, enable the new Use TCPS (or UseTCPS) property. The driver thenencrypts the connection using the SSL settings configured in yoursqlnet.ora configuration file. For more information, see the Installationand Configuration Guide.

  • [ORCL-435] Updated workflow for TNS connections

    When you connect using a connection string or from a non-Windows machine,the TNS Name (or TNS) property now takes precedence over the Host, Port,and Service Name properties (Host, Port, and SVC, respectively).

Install Oracle Odbc Driver

1.2.7 ————————————————————————

Released 2018-10-12

Enhancements & New Features

  • [ORCL-308] Upgrade to Oracle Instant Client 12.2

    The driver now uses version 12.2 of the Oracle Instant Client as adependency. Previously, the driver used version 12.1.

    IMPORTANT:
    • Due to platform support differences in the Oracle Instant Client, themacOS version of the driver no longer supports 32-bit applications.
    • If you installed Oracle Instant Client and the driver through separateinstallation processes, then make sure to manually upgrade Oracle InstantClient to version 12.2. For instructions, see the Installation andConfiguration Guide.

Resolved IssuesThe following issue was resolved in Simba Oracle ODBC Driver 1.2.7.

  • [ORCL-433] The TIMESTAMP WITH TIME ZONE data type is not supported.

    This issue has been resolved. The driver is now able to work with theTIMESTAMP WITH TIME ZONE data type from Oracle databases, mapping it tothe SQL_TYPE_TIMESTAMP data type.

1.2.6 ————————————————————————

Released 2018-09-12

Oracle Odbc Driver Configuration Fetch Buffer Size For Mac

Resolved IssuesThe following issues were resolved in Simba Oracle ODBC Driver 1.2.6.

  • [ORCL-259] Error messages produced by the driver are not formattedcorrectly.

  • [ORCL-427] In some cases the driver returns NULL values when reading largeamounts of rows.

1.2.5 ————————————————————————

Released 2018-07-18

Enhancements & New Features

  • [ORCL-381] Error messages enhanced

    When you enter an invalid character or a value outside the acceptablerange for 'Statement Cache Size' or 'Fetch Buffer Size' in the DSN setup,

    the driver now displays an error message that includes more informationabout the values that you entered.

  • [ORCL-348] Updated encryption method for driver on Windows

    The driver now uses the DPAPI encryption method to make sure that thecredentials can only be used by the current user (for User DSNs) or usedby all users on the same machine (for System DSNs). The registry contentscannot be used to create the same user DSN or system DSN on anothercomputer. Also, the user DSN registry contents cannot be used to createa system DSN on the same computer.

1.2.4 ————————————————————————

Microsoft Odbc For Oracle Driver

Released 2018-06-05

Enhancements & New Features

  • [ORCL-375] Updated log file name

    The log file that the driver generates when logging is enabled has beenrenamed from oracle_driver.log to simbaoracleodbcdriver.log.

  • [ORCL-353] Internal Driver Improvements

    The driver has been updated with internal security improvements.

Resolved IssuesThe following issues were resolved in Simba Oracle ODBC Driver 1.2.4.

  • [ORCL-366] Driver displays an incorrect alert for data source namevalidation.

    This issue has been resolved. When adding a DSN through the ODBCAdministrator, if you enter invalid characters in the Data Source Namefield, the driver now displays an alert with the correct message andprevents you from using invalid characters.

  • [ORCL-362] Driver incorrectly handles SQL queries having argumentof zero length.

    This issue has been resolved. When a SQL query with an argument lengthequal to zero is run, the driver now responds with the correct errormessage such as 'Invalid string or buffer length'.

1.2.3 ————————————————————————

Released 2018-04-25

Enhancements & New Features

  • Driver supports statement caching

    You can now cache statements using the driver. Use this feature if youwant to improve driver performance for parsing the same statement multipletimes in the same connection. Make sure that you enable statement cachingonly when required because statement caching requires more memory. For moreinformation, see the Installation and Configuration Guide.

  • Upgrade to OpenSSL 1.1.0h

    The driver now uses OpenSSL 1.1.0h for encryption of data.

  • MEMLIM option available through the user interface

    The MEMLIM configuration option, which was available only as a key name, isnow accessible via the Windows user interface for the driver. Use the FetchBuffer Size field to configure MEMLIM through the user interface. For moreinformation, see the Installation and Configuration Guide.

1.2.2 ————————————————————————

Released 2018-02-28

Enhancements & New Features

  • Support for the Basic Light Oracle Instant Client

    You can now use the Basic Light version of the Oracle Instant Clientpackage. This Basic Light package requires less disk space comparedto the Basic Package.

1.2.1 ————————————————————————

Released 2018-02-09

Resolved IssuesThe following issues were resolved in Simba Oracle ODBC Driver 1.2.1.

  • Under some circumstances the driver calls deprecated OCI functions.

  • During installation the system message 'Error creating temporary swapfile name' may appear.

  • When you link data to your data source in Microsoft Access, an error mayoccur, displaying an error message such as 'Reserved error (-7745); thereis no message for this error.'

1.2.0 ————————————————————————

Released 2017-12-12

Resolved IssuesThe following issue was resolved in Simba Oracle ODBC Driver 1.2.0.

  • In some cases, the registry entries or error logs generated by the drivermay contain some sensitive information.




broken image