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

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

CHL — Fri, 27 Feb 2015 10:05:37 GMT

Hi Guys,

I am getting the error:

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

The Server is running Red Hat Linux with an Oracle 11G R2 Database (64 bit).

Having read other threads all over the internet I am still no further.

I have tried Selecting just a single column so I know its not a data type issue. I have installed the newest 64 bit oracle drivers for Windows and I can make the ODBC Connection but I cannot query from Qlik.

I hope someone can help!

Chris

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

Gysbert_Wassenaar — Fri, 27 Feb 2015 17:55:28 GMT

Perhaps you're running into this problem: Error while fetching tables through ODBC connection

If not, you'll have to find out column for column where the problem arises.

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

CHL — Mon, 09 Mar 2015 15:26:57 GMT

It wasn't that problem. Still actually unsure what the root cause was/is. I got round it by using an OLE DB connection. Thanks for your help.