2 Replies Latest reply: Jul 23, 2010 4:25 AM by Nick Swift RSS

    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.