ODBC Driver 1.0.10 release notes

ODBC driver product enhancements and updates in the 1.0.10 release.

Activation information

Download the 1.0.10 version of the ODBC Driver from the HI Knowledge Base. Refer to the product documentation for instructions on installing the ODBC driver.

New in the 1.0.10 release

Improvements to timer and duration fields
The display format for timer and duration fields has been improved. Queries on timer and duration fields now return the field value in the UTC timezone. You can query the field display value, as shown in the UI, by adding dv_ to the field name. The property LegacyDurationTimeZone has been added to preserve compatibility with legacy integrations.
Database schema and caching properties
The EnableDBSchema and ExtendedSchemaCache properties enable you to control how the ODBC driver queries and caches database schemas.

Notable Fixes

Problem Short description Steps to reproduce
PRB634397

KB0551938

ODBC driver fails to get data or connect when invoking multiple or parallel connections.

Refer to the listed Known Error KB article for details.

PRB637895 ODBC select query does not return columns in the defined order.
  1. Using the ODBC driver version 1.0.9, run a select query.
  2. Note the returned column order is random.

PRB630646

KB0549682

ODBC driver caches schema between different connections.

Refer to the listed Known Error KB article for details.

PRB630233

KB0549578

The ODBC driver does not use the SOAP aggregate API for aggregate queries.

Refer to the listed Known Error KB article for details.

PRB629818

KB0549557

ODBC driver does not optimize select top N queries.

Refer to the listed Known Error KB article for details.