Release notes for ODBC Driver for Oracle

Version 6.0

• Added a graphical interface for configuring the driver on macOS and Linux.
• Added support for REF_CURSOR parameters in stored procedures and functions to retrieve them as Result Sets.
• Added support for the BOOLEAN data type in Oracle 23c and later.
• Added support for passwords longer than 30 characters in Oracle 23c and later.
• Added support for the Bearer Token authentication when using an HTTP tunnel.
• Improved compatibility with SAP Crystal Reports.
• Improved compatibility with Node.js.
• Improved compatibility with Tableau.
• Improved compatibility with Vectorworks.

Version 5.3

• Added support for the BOOLEAN data type in Oracle 23 and later.
• Added support for password-protected private keys for the SSL protocol.
• Improved compatibility with Microsoft Query.

Version 5.2

• Added the IgnoreCommandTimeout connection string parameter.

Version 5.1

• Fixed connection timeout setting before opening a connection.
• Improved compatibility with FileMaker Server on Linux and macOS.
• Added the storage of passwords in an encrypted form in the DSN record.
• Added the read-only mode for the connection.

Version 5.0

• Added support for Oracle 23c.
• Improved compatibility with 4D on macOS.

Version 4.3

• Added support for the SQL_ATTR_MAX_ROWS attribute.
• Improved compatibility with Visual Basic in Visual Studio.
• Added support for macOS 13 Ventura.
• Improved compatibility with Tableau Prep Builder.
• Improved compatibility with Crystal Reports.
• Improved the SSH connection establishment.
• Reduced the number of metadata calls.

Version 4.2

• Added support for Windows 11.
• Improved compatibility with FICO Mosel.
• Improved compatibility with FileMaker.
• Improved compatibility with JMP on macOS.
• Improved support for an ODBC installer on Windows 2000.

Version 4.1

• Added MSI installer for deploying through GPO.

Version 4.0

• Added support for Apple Silicon M1.
• Added support for Oracle 21c.
• Improved compatibility with macOS Big Sur.

Version 3.3

• Added support for Oracle 20c.
• Added support for the connection via the SSL protocol.
• Added support for the connection via the SSH protocol.
• Added support for the connection via the HTTP tunnel.

Version 3.2

• Added support for long database object names.
• Added the possibility of mapping DATE time to SQL_TYPE_DATE rather than SQL_TYPE_TIMESTAMP.
• Improved compatibility with Power Pivot.
• Improved compatibility with Visual Basic.
• Improved compatibility with RStudio.

Version 3.1

• Added support for Oracle 19c.
• Improved thread-safety of the ODBC driver.
• Added the possibility of activation of the ODBC driver without administrator privileges.
• Improved compatibility with sandboxed applications on macOS.
• Improved support for connection pooling.

Version 3.0

• Added support for Oracle 18c.
• Added macOS distribution of the ODBC driver as a PKG package.
• Added Linux distribution of the ODBC driver as DEB and RPM packages.
• Added the possibility of forcing the ODBC 2.x behavior.

Version 2.4

• Added the possibility to return String Types as Ansi or Unicode.
• Improved compatibility with MS Access.
• Improved compatibility with Tableau.
• Improved compatibility with Omnis Studio.
• Improved compatibility with Power Pivot.
• Improved compatibility with DBeaver.

Version 2.3

• Improved performance of batch operations.

Version 2.2

• Improved compatibility with SAS JMP.
• Improved compatibility with MS Power Query.
• Added support for the OUTER JOIN macros in SQL queries.
• Added support for the DateTime macros in SQL queries.
• Added support for the Scalar function macros in SQL queries.
• Added support for NChar literal replacement.
• Improved metadata retrieval for Oracle 8.

Version 2.1

• Added support for Oracle Cloud in the Direct mode.
• Added the option to display metadata only for the current scheme.
• Improved compatibility with MS Visual Studio.
• Improved compatibility with MS FoxPro.
• Improved compatibility with MapInfo.
• Improved compatibility with Libre Office.
• Improved compatibility with Qlik.
• Improved compatibility with Delphi & C++Builder.
• Improved support for MS Access linked tables.

Version 2.0

• Added support for Linux.
• Added support for macOS.
• Improved support for stored procedures and functions.
• Improved backward compatibility of SQLExecDirect with ODBC 2.x.
• Improved compatibility with MS Excel.
• Improved compatibility with ODBC 2.x.
• Fixed Trial expiration in Microsoft SQL Server Management Studio.
• Fixed the fetching of a large amount of data.

Version 1.2

• Improved compatibility with Microsoft Visual Studio.
• Improved compatibility with Microsoft Office.
• Improved compatibility with Microsoft SQL Server Management Studio.
• Improved compatibility with Crystal Reports.
• Improved compatibility with ClikView.
• Improved support for metadata stored procedures.
• Improved support for interval data types.

Version 1.1

• Improved performance.

Version 1.0

• First release of Devart ODBC Driver for Oracle
• Added support for:
  • Windows 32-bit
  • Windows 64-bit