Error while fetching tables through ODBC connection

[Anonymous]

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?

[ashfaq_haseeb]

Hi

It looks like your ODBC drivers does not support.

Try by downloading other drivers.

Regards

ASHFAQ

[Anonymous · Accepted solution]

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.

[ananyaghosh]

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

[Anonymous]

It's the timestamp with Timezone that's creating problem, normal timestamp column should work fine

[hugheser27]

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.

[asthenia_182x]

to format date

to_char(dstamp, 'MM/DD/YYYY')

to format time

to_char(dstamp, 'HH:MM')