topic Re: ODBC read railed in QlikView

ODBC read railed

vireshkolagimat — Fri, 13 Jan 2017 07:32:43 GMT

Hi All,

I'm loading data from Oracle database but when i hit the the reload button getting the error "ODBC read failed".

Any idea what is wrong and hot to fix it.

Thanks for your help.

Regards,

Viresh

Re: ODBC read railed

zhadrakas — Fri, 13 Jan 2017 08:19:03 GMT

sometimes i got this error if one fieldname is twice in one table.

check your aliases.

Re: ODBC read railed

MK_QSL — Fri, 13 Jan 2017 09:02:12 GMT

Remove the connection string and recreate the connection string...

Re: ODBC read railed

avinashelite — Fri, 13 Jan 2017 09:08:13 GMT

Share the complete log file ...

Re: ODBC read railed

vireshkolagimat — Fri, 13 Jan 2017 09:23:27 GMT

SQL query is running in but when i use the same query in Qlikiview script editor, i am getting the error.

Re: ODBC read railed

vireshkolagimat — Fri, 13 Jan 2017 09:23:54 GMT

I tried but no result. thanks

Re: ODBC read railed

vireshkolagimat — Fri, 13 Jan 2017 09:25:08 GMT

you mean the QlikView log file. Due to some reason i can't share it but i looked at the log file , not enough infomrmation. Thanks

Re: ODBC read railed

Anonymous — Fri, 13 Jan 2017 14:40:52 GMT

I've gotten that error when there's been a mismatch between the driver and the settings that I'm using for the connection. In the script editor, there is a checkbox that says "Force 32-bit". Have you tried changing your settings there?

Re: ODBC read railed

vireshkolagimat — Fri, 13 Jan 2017 15:56:19 GMT

Hi, yes i tired to reload after changing the Force 32 bit option but still getting the same error.

thanks

Re: ODBC read railed

vishsaggi — Fri, 13 Jan 2017 16:04:30 GMT

IS the ODBC connection getting established, if yes, can you use select button and tell us if you can see the tables ?