"Odbc driver returned an error (SQLExecDirectW)" Error Whhen Using SQL Results in a Prompt
(Doc ID 2413506.1)
Last updated on MARCH 18, 2021
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0  and later
Information in this document applies to any platform.
You have created a dashboard prompt and are using SQL Results for Choice List Values. Your SQL has a sub-query of the form:
SELECT FROM (SELECT <column> FROM <table>) <alias>
When you try to display the results this error is displayed in the dropdown:
Failed to load(Odbc driver returned an error (SQLExecDirectW).)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document