Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
After upgrading to OBIEE12c getting odbc driver error
After OBIEE upgrade I am facing "Odbc driver returned an error (SQLExecDirectW)"
All reports are erroring out
Answers
-
http://catb.org/~esr/faqs/smart-questions.html#beprecise Expand the error message - what's the detailed error message? Check the Presentation Services and BI Server logs. You'll find the error, and probably the cause, directly there.
0 -
Beaten to the punch by Robin. Needs more detail. Needs more analysis.
0 -
2636702 wrote:
After OBIEE upgrade I am facing "Odbc driver returned an error (SQLExecDirectW)"
All reports are erroring out
Not going to repeat what Christian and Rmoff posted, but also opening a thread with a link to a MOSC thread 1 year old ... what's the theory? First a MOSC space is something else and with limited access vs this one being public. And I guess you could at least write your own question
0 -
Its my own question, and I am facing it currently in the upgrade process.
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified. (HY000)
0 -
Out of interest, what research have you done so far into the error? On the forum we love to help people out, but it cuts both ways - you need to show you've put in some leg work already. That error is a massively common one. Have you gone to My Oracle Support, for example, to look it up? Or searched the forum history to see common causes, and investigated whether they're applicable to your environment?
0 -
