Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Francisco_SP
Contributor II
Contributor II

Run Stored Procedure from SQL Microsoft

Hi,

I'm trying to run the below script (Stored Procedure) in the load editor. 

LIB CONNECT TO 'Microsoft_SQL_Server_FWSQL001 (freeway_peter bann)';

Load *;

SQL
exec [SP_DS_CLAIMS_SUB] 'D3E975C4D671489DBE22BA63E2B19500', 22, 1, 0, 'CLM';

It retuns the next error message:

The following error occurred:
Connector reply error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.
 
Anyone knows how can I fix this error please?
 
Thanks in advance 🙂
Labels (2)
3 Replies
jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi, 

I think this has nothing to do with the connection. It is a security config issue, so you may contact the administrator to enable stored procedures executions.

Also, you can try with oledb and odbc connection to see if the error disappears,

 

regards

Sue_Macaluso
Community Manager
Community Manager

@Francisco_SP  Are you using QlikView or Sense?  I would like to move this into the correct product forum. 

Sue Macaluso
Francisco_SP
Contributor II
Contributor II
Author

Qlik sense