6 Replies Latest reply: Jun 29, 2016 1:55 PM by Vikram Vangala RSS

    odbc read failed while executing sp

    Deepak Subramoniam

      hi folks,

       

      i have a table having 14000 records and 3 columns in a table called tableserver. i created a sp as following in sql server

       

      create procedure spc_test

      as

      begin

           select top 1 col1,col2,col3 from tableserver

      end

       

      i tried to exec this sp through Qlik

       

      ODBC CONNECT32 TO server;

       

      SQL exec spc_test;

       

      getting following error while reloading the script

       

      ODBC read failed

      SQL exec spc_test

       

      but the same time if i query the records in qlikview, it fetching all the 14000 records

      ODBC CONNECT32 TO server;

       

      SQL select * from tableserver ;

       

      Request you to kindly clarify the behavior and help us on this issue for using sp.

       

      Thanks in Advance...

      With Regards

      Deepak Subramoniam