Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

ODBC Read Failed Error

I am having a strange issue when connecting to a SQL Server 2005 via ODBC on a 64-bit Qlikview Desktop.

My script is trying to execute two different stored procedures from the same db. The first executes fine. The second SP causes an error "ODBC Read Failed". In fact, this SP fails if I just run it by itself with the same error.

Both SPs run fine via SQL Studio. There are no differences in the properties between the two SPs either. I just can't see how the ODBC driver can have a problem with one and not the other! I'm connecting via a standard ODBC SQL Server 2005 connector.

I've also tried restarting everything, no joy.

Any help much appreciated.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

ODBC Read Failed Error

Hi Nick,

I had the same problem also which started after I created aliases for field names in my SQL and Load statement. When I removed the alias ClientNumber AS "Client Number" I no longer received the error message.

ODBC Error message ClientNumber AS "Client Number"

No ODBC Error message ClientNumber

Hope that helps.

Sarah

2 Replies
Not applicable

ODBC Read Failed Error

Hi Nick,

I had the same problem also which started after I created aliases for field names in my SQL and Load statement. When I removed the alias ClientNumber AS "Client Number" I no longer received the error message.

ODBC Error message ClientNumber AS "Client Number"

No ODBC Error message ClientNumber

Hope that helps.

Sarah

Not applicable

ODBC Read Failed Error

Hi Sarah,

I've got a little more investigation to do but this definitely looks like the problem!

Thanks very much!

Nick