Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I try to execute a stored procedure I get an error "OLEDB read failed". I reduced the stored procedure to only one column so that shouldn't be the problem. When searching the internet I found that using Qlikview you need to set the connection to be in write mode. But I can't do that in Qlik Sense. Any ideas?
My misstake I did a select in the begining of the SP just for debug purposes that didn't have a column name. When removed it worked
If I add (mode is write) at the end of the connection string I get this error instead
"Db write mode requires the DB write mode flag to be set on the script!"
Hello.
Check this box.
I am using Qlik Sense
Hmm sorry, this is not Sense screen )
My misstake I did a select in the begining of the SP just for debug purposes that didn't have a column name. When removed it worked