What's new in ODBC Driver for xBase 5.0.0
Mar 14, 2024
- Added support for the UTF8 encoding
- Added support for tables with duplicate column names
- Improved compatibility with Quantum GIS
- Improved compatibility with ETL Informatica PowerCenter
- Improved MS Access linked tables support
- Improved error handling when using the IgnoreDataErrors option
- Improved compatibility with FileMaker Server for Linux and macOS
- Fixed bug with editing tables where there are nullable columns in MS Access
New in ODBC Driver for xBase 4.1.0 (Oct 4, 2023)
- Added support for the CREATE TABLE AS SELECT statement
- Fixed bug with driver license validation for Linked Server in MSSMS
New in ODBC Driver for xBase 4.0.0 (Aug 19, 2023)
- Improved significantly the performance of DML operations
- Improved compatibility with Power BI Desktop
- Improved compatibility with 4D in macOS
- Added support for CREATE TABLE IF NOT EXISTS and DROP TABLE IF EXISTS statements
- Fixed bug with data conversion when using YEAR, MONTH and DAY functions
- Fixed bug with getting data in DBeaver
- Fixed Windows XP installation bug
New in ODBC Driver for xBase 3.3.1 (May 17, 2023)
- Added support for SQL_ATTR_MAX_ROWS attribute
- Improved compatibility with Visual Basic in Visual Studio
- Fixed an issue with Assertion Failure when using the ROUND() function
- Fixed an issue with incorrect results of a SELECT statement with JOIN of a table to itself
- Fixed an issue with incorrect results of a SELECT statement with WHERE on a character field
New in ODBC Driver for xBase 3.3.0 (Nov 18, 2022)
- Added support for macOS 13 Ventura
- Added support for VisualFoxPro CANDIDATE indexes
- Added support for NOT function in index expressions
- Improved compatibility with Microsoft Power BI Desktop
- Improved compatibility with Tableau Prep Builder
- Improved compatibility with Crystal Reports
- Fixed bug with writing MEMO field values on Linux
- Fixed bug with Memo fields values comparison
- Fixed bug with a "Can not find a memo file" after dropping the last memo field
- Fixed bug when a connection string parameter value contains a single quote
- Fixed an issue with adding DSN in PowerShell
- Fixed an issue with rows deleting
New in ODBC Driver for xBase 3.2.1 (Jan 5, 2022)
- 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
- Fixed an issue with reading logical fields that contain Y/N values
- Fixed an issue with updating date and time fields in MS Access
New in ODBC Driver for xBase 3.1.1 (Jul 12, 2021)
- MSI installer for deploying through GPO is added
New in ODBC Driver for xBase 3.0.1 (Jul 12, 2021)
- Apple Silicon M1 is supported
- Compatibility with macOS Big Sur is improved
- Compatibility with Microsoft SQL Server Management Studio is improved
- Compatibility with Microsoft Access is improved
- Suport for Out values in Numeric fields is added
- Work with tables of type dBaseV and dBaseVII with the DBFFormat option set to dfAuto is improved
- Several bugs with handling fields of type MEMO, BLOB, BINARY and VARBINARY are fixed
- Bug with the missing libmongoc and libbson libraries on the macOS and Linux platforms is fixed
- Bug with the TRANSFORM function is fixed
- Bug with AV when an index expression is empty is fixed
New in ODBC Driver for xBase 2.3.1 (Jul 12, 2021)
- Native dBase functions in an SQL statement are supported
- The AllFieldsAsNullable connection option is added
- The IgnoreBrokenTables connection option is added
- Bug with indexes containing date fields is fixed
- Bug with VisualFoxPro indexes containing double fields is fixed
- Bug with using tables whose fields match SQL keywords is fixed
- Bug with incorrect results of date functions is fixed
New in ODBC Driver for xBase 2.2 (Dec 9, 2020)
- The IgnoreIndexErrors connection option is added
- Access to table files when performing queries is optimized
- Improved compatibility with RStudio, Microsoft SQL Server Management Studio, Microsoft Power BI Desktop, Power Pivot, Visual Basic
New in ODBC Driver for xBase 2.1.3 (Oct 7, 2019)
- Now ODBC driver activation does not require administrator privileges
- Support for connection pooling is improved
- Improved compatibility with sandboxed applications for macOS
- The IgnoreDataErrors connection option is added
- The IdentifierCase connection option is added
- Bug with invalid selection of deleted records is fixed
- Bug with storing numeric values is fixed
- Bug with using CTOD, DTOS, TTOC, TTOD and EMPTY functions in index expressions is fixed
- Bug with using a field named RECNO in index expressions is fixed
- Bug with inserting records with empty fields is fixed
- Bug with executing a CREATE TABLE statement is fixed
- Bug with executing a CREATE INDEX statement is fixed
- Bug with reading floating-point values is fixed
- Bug with reading MEMO field values is fixed
- Bug with detecting dBaseIV file format is fixed
New in ODBC Driver for xBase 2.0.2 (Jan 11, 2019)
- Bug with wrong selection of deleted records is fixed
- Bug with storing numeric values is fixed
- Bug with using CTOD, DTOS, TTOC, TTOD and EMPTY functions in index expressions is fixed
- Bug with using a field named RECNO in index expressions is fixed
New in ODBC Driver for xBase 2.0.1 (Jan 9, 2019)
- Now ODBC driver for macOS is distributed as a PKG package
- Now ODBC driver for Linux is distributed as DEB and RPM packages
- Possibility to force the ODBC 2.x behavior is added
- Bug with using the DTOC function in index expressions is fixed
- Bug with using fields that have null values in conditional expressions is fixed
- Bug with opening some VisualFoxPro tables is fixed
New in ODBC Driver for xBase 1.3.4 (Jul 17, 2018)
- Support for Clipper/Harbour is added
- Possibility to show used connection string in the connection dialog is added
New in ODBC Driver for xBase 1.2.3 (Jun 15, 2018)
- Possibility to return String Types as Ansi or Unicode is added
- Compatibility with MS Access is improved
- Compatibility with Tableau is improved
- Compatibility with Omnis Studio is improved
- Compatibility with Power Pivot is improved
- Compatibility with DBeaver is improved
- Compatibility with Codebase is improved
- Bug with importing data in Microsoft Excel using Microsoft Query is fixed
- Bug with getting the "Key fields not found" error is fixed
New in ODBC Driver for xBase 1.1.2 (Feb 27, 2018)
- Performance of batch operations is significantly improved
- The IndexOnReading connection parameter is added
- Bug with opening some dBaseVII tables is fixed
- Bug with reading Visual FoxPro Double fields is fixed