Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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