connecting sql Stored procedure to qlik sense

[bisola1]

please can you assist with guideline on how to connect sql server stored procedure to qlik sense as i am getting this error 'Connector reply error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.: sql exec dbo.qlik_research'

[LDR]

Hi @bisola1 

In Qlik Sense SaaS I don't know where is exactly the place to configure what you need, however in Qlik Sense for Windows you have to edit the file " C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\QvOdbcConnectorPackage.exe.config" and change from False to True they key "allow-nonselect-queries", like in the example below:

<appSettings> 
    <add key="allow-nonselect-queries" value="True"/> 

Regarding Saas I found that: Executing non-SELECT statements ‒ Qlik Cloud

Best regards

[bisola1]

thank you for  your repsonse @LDR , yeah i saw this solution earlier, and i downloaded the qlik sense desktop to be able to view the file path but i couldnt  get the file that has the above queries.

[Levi_Turner]

For Qlik Sense Desktop it should be in %USERPROFILE%\AppData\Local\Programs\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage. %USERPROFILE% is a variable for your user folder (i.e. for me it's C:\users\levi\....).