topic ODBC Read failed in QlikView

ODBC Read failed

dmxmikey — Tue, 23 Jun 2015 15:01:32 GMT

//QUALIFY *;

ODBC CONNECT32 TO Accord (XUserId isxxxxxxxxxxX, XPassword is xxxxxxxxxxxxxx);

RFPKLOGD:

SQL SELECT

assignment,

"bond-status",

depot,

dept,

"e-code",

"loc-status",

"locn-post",

"min-stock",

"move-no",

"o-line",

"o-ordinn",

"o-ordqty",

"o-ordwt",

"o-sentinn",

"o-sentqty",

"o-weight",

"order",

"p-code",

"pk-date",

"pk-hour",

"pk-ind",

"pk-minute",

"pk-second",

"pk-stock",

"pk-stock-in",

"pk-time",

"replen-date",

"replen-move",

"replen-priority",

"replen-time",

"reserve-stock",

"shift-date",

"shift-id",

summarised

FROM PUB.rfpklogd;

STORE RFPKLOGD INTO \\APPSERVER1\QLIKVIEW\QLIKVIEWDATAFILES\QVDS\rfpklogd.qvd;

When i load the above script i get an ODBC read failed error, but i know the connection to Database is ok.

Re: ODBC Read failed

buzzy996 — Tue, 23 Jun 2015 15:05:31 GMT

can u confirm,that ODBC connection is created in User DSN tab or System DSN tab?

Re: ODBC Read failed

dmxmikey — Tue, 23 Jun 2015 16:05:30 GMT

Not sure how to tell but think user

Sent from my iPhone

Re: ODBC Read failed

buzzy996 — Tue, 23 Jun 2015 16:17:53 GMT

u suppose to create that odbc connection on System dsn tab and run tht application through the server..it works.

go to--control panel---administrative tools--data sources..and see whr u r created that odbc connection!

Re: ODBC Read failed

dmxmikey — Wed, 24 Jun 2015 09:34:19 GMT

Just checked and connection is set on system dns

Re: ODBC Read failed

shaktisinghchau — Fri, 15 Dec 2017 06:52:31 GMT

Mike,

I have faced this issue recently it is happen when you have more than one field in your select statement with same name