Discussion Board for collaboration related to QlikView App Development.
SQL##f - SqlState: S1C00, ErrorCode: 3, ErrorMsg: [Oracle][ODBC][Ora]Driver not capable.
We are getting above error while fetching data from ODBC connection. How to resolve this issue?
The issue is fixed, was trying to fetch a column that is defined as TIMESTAMP with TIMEZONE, that was causing the problem. On excluding the column with that datatype, it worked.
View solution in original post
It looks like your ODBC drivers does not support.
Try by downloading other drivers.
I am facing the same problem . So can you explain that what you have did with the data type for that column?
as because if we exclude it, we cannot do the incremental load in my script. So if you have a possible solution for it, please suggest me that approach.
It's the timestamp with Timezone that's creating problem, normal timestamp column should work fine
In the situation where the field is TIMESTAMP with TZ, and I cannot change the DB schema. Is there any way to read the data as string, date but drop the tz, etc? This is blocking me.
to format date
to format time