Error: ""SQL API: [SQLBindCOl], SQL RETURN: [-1], SQL STATE:" in Interactive Reporting Studio If Querying a Column with Uniqueidentifier Data Type of Microsoft SQL Server. (Doc ID 1263925.1)

Last updated on JULY 29, 2016

Applies to:

Hyperion BI+ - Version 11.1.1.2.00 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Feb-2013***

Symptoms

If an Interactive Reporting BQY document queries a column of data type 'uniqueidentifier' in Microsoft SQL Server, it will throw the following error message:

"SQL API: [SQLBindCOl], SQL RETURN: [-1], SQL STATE: [HY003], SQL NATIVE ERROR: [0], SQL MESSAGE: [[Microsoft][ODBC Driver Manager] Program type out of range]"

Changes

In context of using a Microsoft SQL Server ODBC driver.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms