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