Regarding error message while loading stored procedures into Qlik Sense

[#1]

Hi Team,

I am unable to load stored procedures into Qlik Sense.

I am using the following code.

LIB CONNECT TO 'Server name';

load *;

sql  exec [Procedure_Name]  ;

When I execute this code, I am receiving the following error saying that the metadata column could not be determined as the SQL Statement uses a temp table.

ERROR [HY000] [Qlik][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The metadata could not be determined

Any help will be much appreciated.

Thanks and regards,

Ashwin

[phaneendra_kunc]

did you open database in read & write mode? I know this is qlikview, but i want you to try creating connection string as stated in below link and use that string in Qlik sense and see.

Stored Procedure Connection In QlikView Application

[#3]

Hi Phaneendra,

I am able to connect now. I was using Qlik ODBC connector package. When I changed this to an OLEDB connection,it rectified the error. However the stored procedure does not return any rows nor does it prompt me for any parameters

This is the code that I am using.

LIB CONNECT TO 'Server_name';

  load *;

    sql  exec [Procedure_Name] '$(@ParameterName1)','$(@ParameterName2) ';

Please help me regarding this.

Regards,

Ashwin