Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
It looks like your ODBC drivers does not support.
Try by downloading other drivers.
Regards
ASHFAQ
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.
Hi,
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.
Thanks,
Sandip
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_char(dstamp, 'MM/DD/YYYY')
to format time
to_char(dstamp, 'HH:MM')