Page 1 of 1

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

Posted: Mon 13 Apr 2020 18:43
by Devart
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