Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Execute Stored Procedure Failed via OLEDB Connection

Hi experts,

I'm able to get data from a stored procedure using ODBC connection, but failed using OLEDB connection, with the same account, password and all.

Has anybody met this situation?

There's no error message, and the stored procedure did run for a while.

The only problem is that there's no data return.

Can anybody help to explain and solve it?

Thank you in advance.

Best regards,

Patrick

2 Replies
Not applicable

Re: Execute Stored Procedure Failed via OLEDB Connection

Hi all,

I've found the cause.

It's because when using OLEDB, the stored procedure must include "set nocount on" statement.

FYI.

Not applicable

Re: Execute Stored Procedure Failed via OLEDB Connection

Thanks! This worked for me as well and corrected the issue. QV needs to fix ASAP. Thanks again for the help!!

Community Browser