Stored procedure OLEDB read failed

[#1]

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?

[#2]

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!"

[ikarimov]

Hello.

Check this box.

[#4]

I am using Qlik Sense

[ikarimov]

Hmm sorry, this is not Sense screen )

[#6 · Accepted solution]

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