Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • Madrid
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

ODBC Driver patch release notes

Log in to subscribe to topics and get notified when content changes.

ODBC Driver patch release notes

The ODBC Driver is updated with each new family release, and problem fixes are included in driver patch updates.

Download the ODBC driver from the HI Knowledge Base. For installation and configuration information, refer to Installing the ODBC driver.

ODBC Driver 1.0.14.01 release notes

The ODBC Driver 1.0.14.01 release contains fixes to these problems.

Fixed problem Short description

Open Database Connectivity (ODBC)

PRB1282816

When a ServiceNow ODBC user types incorrect user credentials, 4 login.failed events are created instead of 1

ODBC Driver 1.0.14 release notes

The ODBC Driver 1.0.14 release contains fixes to these problems.

Fixed problems Short description Description

Open Database Connectivity (ODBC)

PRB1162624

A ODBC query to a 'string' with the value of a field name will translate to the incorrect 'same as' query, returning incorrect rows When using ODBC to query to a 'string' that matches the value of a field name, it translates to an incorrect 'same as' query. The incorrect query can return the incorrect rows.

Open Database Connectivity (ODBC)

PRB1267497

The JRE was removed from ODBC installers

Open Database Connectivity (ODBC)

PRB1278032

64-bit ODBC Driver fails to connect to instances hosted in FedRAMP datacenter due to TLSv1.2 requirements

FedRAMP data centers no longer allow for connections made with TLSv1.1 or lower. The 64-bit version of the 1.0.13 driver uses JDK 1.8.152, which has been known to have issues with TLS. As a result, the server rejects the connection when falling back to the next highest version.

For symptoms, cause, and resolution information, see KB0563593 in the HI Knowledge Base.

ODBC Driver 1.0.13 release notes

The ODBC Driver 1.0.13 release contains fixes to these problems.

Fixed problems Short description Description

Open Database Connectivity (ODBC)

PRB1110116

ODBC driver returns non-integer fields as NTEXT where varchar is expected

Users cannot use ODBC driver 1.0.11 correctly in combination withL: SQL Version: Microsoft SQL Server 2014 (SP2-CU2-GDR) (KB3194718) - 12.0.5532.0 (X64) Oct 5 2016 20:28:25 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

"SELECT INTO" queries cause the ODBC driver to convert fields to NTEXT where varchar is expected instead.

ODBC Driver 1.0.12 release notes

ODBC driver product enhancements and updates in the 1.0.12 release.

Version 1.0.12 of the ODBC Driver uses Java 1.8. You may need to configure your Java path after installing this version. See KB0597981 for more information.
Fixed problems Short description

PRB708941

KB0597404

Querying more than 4MB with ODBC driver creates temp files

PRB747962

KB0621993

ODBC driver outputting incorrect number of records when using LEFT JOIN ON SELECT * query

ODBC Driver 1.0.11 release notes

ODBC driver product enhancements and updates in the 1.0.11 release.

Version 1.0.11 of the ODBC Driver uses Java 1.8. You may need to configure your Java path after installing this version. See KB0597981 for more information.
Fixed problems Short description

PRB711960

KB0597602

When querying a table that has a string field whose value exceeds 65535 kb, the following error occurs:

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Disk cache error. Field length:93238 exceeds maximum limit of 65535

PRB691056

KB0597979

ODBC query on Display Value for a state does not return the entire Display Value

PRB716125

KB0598308

iSQL returns only 16383 bytes even if a field contains more data

ODBC Driver 1.0.10 release notes

ODBC driver product enhancements and updates in the 1.0.10 release.

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.

Fixed problems

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 doesn't 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.
Feedback