topic Error while fetching tables through ODBC connection in QlikView

Error while fetching tables through ODBC connection

Anonymous — Wed, 02 Jul 2014 11:39:15 GMT

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?

Re: Error while fetching tables through ODBC connection

ashfaq_haseeb — Wed, 02 Jul 2014 12:00:43 GMT

It looks like your ODBC drivers does not support.

Try by downloading other drivers.

Regards

ASHFAQ

Re: Error while fetching tables through ODBC connection

Anonymous — Thu, 31 Jul 2014 09:59:34 GMT

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.

Re: Error while fetching tables through ODBC connection

ananyaghosh — Thu, 25 Jan 2018 09:47:17 GMT

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

Re: Error while fetching tables through ODBC connection

Anonymous — Thu, 25 Jan 2018 13:38:29 GMT

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

Re: Error while fetching tables through ODBC connection

hugheser27 — Mon, 29 Apr 2019 18:26:54 GMT

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.

Re: Error while fetching tables through ODBC connection

asthenia_182x — Wed, 02 Oct 2019 13:16:55 GMT

to format date

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

to format time

to_char(dstamp, 'HH:MM')