QlikView 12.02.04 Error while fetching tables through ODBC

[macpao64]

QlikView 12.02.04   - Error while fetching tables through ODBC connection

SQL##f - SqlState: S1C00, ErrorCode: 3, ErrorMsg: [Oracle][ODBC][Ora]Driver not capable.

LOAD CONNID,
DATA_UPDATE,
FLOW,
FLOW_STEP;
SQL SELECT *
FROM "CRM_SF_IF".PROVA2;

I’m trying to fetch a column that is defined as TIMESTAMP with TIMEZONE, that is causing the problem.

If I comment the column with that datatype into the load script, it doesn’t work yet.

I would not change the column size on the db, is there some solution to keep the TIMEZONE?

Thanks a lot

Paolo

[Clever_Anjos]

Another test, if possible.

Try using the OLEDB Oracle Driver instead of ODBC

[macpao64]

It's ok using OLEDB

Thanks