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.
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';
sql exec [Procedure_Name] '$(@ParameterName1)','$(@ParameterName2) ';
Please help me regarding this.