New versions of ODBC Drivers: Oracle, PostgreSQL, QuickBooks, xBase

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Locked
Devart
Site Admin
Posts: 3974
Joined: Tue 26 Oct 2004 13:51

New versions of ODBC Drivers: Oracle, PostgreSQL, QuickBooks, xBase

Post by Devart » Mon 13 Apr 2020 18:43

Hello,

We've released new versions of ODBC drivers for Oracle, PostgreSQL, QuickBooks, xBase.

What's new in ODBC driver for Oracle:
  • Long database object names are supported
  • Possibility of mapping DATE time to SQL_TYPE_DATE rather than SQL_TYPE_TIMESTAMP is added
  • Compatibility with Power Pivot is improved
  • Compatibility with Visual Basic is improved
  • Compatibility with RStudio is improved
  • Bug with modifying data using SQLSetPos is fixed
  • Bug with fetching by Bookmark is fixed

What's new in ODBC driver for PostgreSQL:
  • Materialized views are supported
  • Compatibility with Power Pivot is improved
  • Compatibility with Visual Basic is improved
  • Compatibility with RStudio is improved
  • Bug with modifying data using SQLSetPos is fixed
  • Bug with fetching by Bookmark is fixed

What's new in ODBC driver for QuickBooks:
  • Token lifetime is increased
  • Compatibility with Power Pivot is improved
  • Compatibility with Visual Basic is improved
  • Compatibility with RStudio is improved
  • Bug with modifying data using SQLSetPos is fixed
  • Bug with fetching by Bookmark is fixed

What's new in ODBC driver for xBase:
  • The IgnoreIndexErrors connection option is added
  • Access to table files when performing queries is optimized
  • Compatibility with RStudio is improved
  • Compatibility with Microsoft SQL Server Management Studio is improved
  • Compatibility with Microsoft Power BI Desktop is improved
  • Compatibility with Power Pivot is improved
  • Compatibility with Visual Basic is improved
  • Bug with using native indexes when performing SQL queries is fixed
  • Bug with using character fields in a WHERE clause is fixed
  • Bug with opening tables, which path contains a dot, is fixed
  • Bug with reading timestamp field values is fixed
  • Bug with using date fields in a WHERE clause on Linux is fixed
  • Bug with opening tables, which field names match SQL keywords, is fixed
  • Bug with modifying data using SQLSetPos is fixed
  • Bug with fetching by Bookmark is fixed

Locked