IBM DB2 ODBC driver fails with DateTime
Article ID: KB0078266
Updated On:
| Products | Versions |
|---|---|
| TIBCO Scribe Insight | 7.9.2 |
Description
Issue : Using Scribe® Wire Protocol ODBC driver to connect to DB2 results in an error.
Error: The following error message is shown:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Error Number: 65408
Source: ADP
Error: The following error message is shown:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Error Number: 65408
Source: ADP
Issue/Introduction
BLANK
Resolution
You cannot use a DateTime that is using a date earlier than the current date. To test this, replace the DateTime values with NULL in your SQL query and it should no longer fail.
Feedback
Yes
No
Powered by
