Release notes for ODBC Driver for xBase

Version 6.1

• Added the Read Only connection mode.
• Improved compatibility with Attunity Qlik Replicate.
• Improved compatibility with the PDO_ODBC PHP extension.
• Improved compatibility with Node.js.

• Version 6.0

• Added a graphical interface for configuring the driver on macOS and Linux.
• Improved support for the HiPerSix database format.
• Improved compatibility with Node.js.
• Improved compatibility with Tableau.
• Improved compatibility with Vectorworks.

Version 5.1

• Added support for the BITTEST SQL function.

Version 5.0

• Fixed connection timeout setting before opening a connection.
• Added support for the UTF-8 encoding.
• Added support for tables with duplicate column names.
• Improved compatibility with Quantum GIS.
• Improved compatibility with ETL Informatica PowerCenter.
• Improved support for MS Access linked tables.
• Improved error handling when using the IgnoreDataErrors option.
• Improved compatibility with FileMaker Server on Linux and macOS.

Version 4.1

• Added support for the CREATE TABLE AS SELECT statement.

Version 4.0

• Improved performance of DML operations.
• Improved compatibility with Power BI Desktop.
• Improved compatibility with 4D on macOS.
• Added support for CREATE TABLE IF NOT EXISTS and DROP TABLE IF EXISTS statements.

Version 3.3

• Added support for the SQL_ATTR_MAX_ROWS attribute.
• Improved compatibility with Visual Basic in Visual Studio.
• Added support for macOS 13 Ventura.
• Added support for VisualFoxPro CANDIDATE indexes.
• Added support for the NOT function in index expressions.
• Improved compatibility with Microsoft Power BI Desktop.
• Improved compatibility with Tableau Prep Builder.
• Improved compatibility with Crystal Reports.

Version 3.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.
• Added support for the Autoinc data type in Visual FoxPro tables.
• Added support for the YEAR, MONTH, and DAY functions in index expressions.

Version 3.1

• Added an MSI installer for deployment via Group Policy (GPO).

Version 3.0

• Added support for Apple Silicon M1.
• Improved compatibility with macOS Big Sur.
• Improved compatibility with Microsoft SQL Server Management Studio.
• Improved compatibility with Microsoft Access.
• Added support for the Out values in Numeric fields.
• Improved support for dBaseV and dBaseVII tables when the File Format option is set to Auto.

Version 2.3

• Added support for native dBase functions in an SQL statement.
• Added the AllFieldsAsNullable connection option.
• Added the IgnoreBrokenTables connection option.

Version 2.2

• Added the IgnoreIndexErrors connection option.
• Optimized access to table files when executing queries.
• Improved compatibility with RStudio.
• Improved compatibility with Microsoft SQL Server Management Studio.
• Improved compatibility with Microsoft Power BI Desktop.
• Improved compatibility with Power Pivot.
• Improved compatibility with Visual Basic.

Version 2.1

• Added the ability to activate the ODBC driver without administrator privileges.
• Improved support for connection pooling.
• Improved compatibility with sandboxed applications on macOS.
• Added the IgnoreDataErrors connection option.
• Added the IdentifierCase connection option.

Version 2.0

• Added a PKG installation package for the ODBC driver for macOS.
• Added DEB and RPM installation packages for the ODBC driver for Linux.
• Added the ability to force the ODBC 2.x behavior.

Version 1.3

• Added support for Clipper/Harbour.
• Added the ability to display the used connection string in the connection dialog.

Version 1.2

• Added the ability to return string types as ANSI or Unicode.
• Added compatibility with MS Access.
• Added compatibility with Tableau.
• Improved compatibility with Omnis Studio.
• Improved compatibility with Power Pivot.
• Improved compatibility with DBeaver.
• Improved compatibility with Codebase.

Version 1.1

• Improved performance of batch operations.
• Added the IndexOnReading connection parameter.

Version 1.0

• First release of Devart ODBC Driver for xBase.
• Added support for:
  • Windows
  • Linux
  • macOS