topic ODBC read failed in QlikView

ODBC read failed

Fri, 17 Sep 2010 08:17:05 GMT

Hi All,

When I debug Script got finished successfully but when I reload the complete data in to the qlikview I am getting the error as "ODBC read failed". Why that error was not shown when I debugged it and also let me know the cause of this error and how can I avoid the same.

Please look in the attached screen shot for your reference.

ODBC read failed

sunil2288 — Fri, 17 Sep 2010 08:25:14 GMT

HI Rikab,

You have not provided the ODBC Connection string..

Make sure which datbase you are connecting to.. qlikview will automatically derive the connection string using ODBC Driver..

Regards,

Sunil

ODBC read failed

Fri, 17 Sep 2010 08:29:13 GMT


SUNIL KUMAR PANDA wrote:
You have not provided the ODBC Connection string..
Make sure which datbase you are connecting to.. qlikview will automatically derive the connection string using ODBC Driver.. <div></div>

ODBC Connection String has been provided. There is no issue with that as I am able to load the other tables using the same ODBC Connection string.

Connection string is happening that's the reason I am able to load the data from other tables.

ODBC read failed

sunil2288 — Fri, 17 Sep 2010 09:27:26 GMT

Hi Rikab,

There may be the case that when you are trying to fetch the entire table after debugging..

at athe same time an updation to the table may be going on.

that's y when you are debugging the script it is fetching only few of the rows .. but at the time when you are reloading the whole table the ODBC read Get failure

Regards,

Sunil

ODBC read failed

jonathandienst — Fri, 17 Sep 2010 10:09:16 GMT

Rikab

Did you do a limited load for the debug run?

If so, then the problem could be related to the size of the data when you do a full load, and I suggest you do a debug run without using limited load.

Jonathan