Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Stored procedure OLEDB read failed

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?

1 Solution

Accepted Solutions
Not applicable

Re: Stored procedure OLEDB read failed

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

5 Replies
Not applicable

Re: Stored procedure OLEDB read failed

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
New Contributor II

Re: Stored procedure OLEDB read failed

Hello.

Check this box.

179214.jpg

Not applicable

Re: Stored procedure OLEDB read failed

I am using Qlik Sense

ikarimov
New Contributor II

Re: Stored procedure OLEDB read failed

Hmm sorry, this is not Sense screen )

Not applicable

Re: Stored procedure OLEDB read failed

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