BICS : Odbc driver returned an error (SQLExecDirectW)

(Doc ID 2281372.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Oracle Data Visualization Cloud Service - Version 15.4.3 and later
Information in this document applies to any platform.

Goal

BICS error " [nQSError: 100031] Unknown Call interface type JDBC (JNDI)" while using RDC

BICS is generating the following error when using RDC:
Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 100031] Unknown Call interface type JDBC (JNDI).


Solution

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