Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bisola1
Contributor
Contributor

connecting sql Stored procedure to qlik sense

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'

Labels (1)
3 Replies
LDR
Creator II
Creator II

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
Contributor
Contributor
Author

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
Employee
Employee

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\....).