topic Execute Stored Procedure Failed via OLEDB Connection in QlikView

Execute Stored Procedure Failed via OLEDB Connection

Mon, 24 Mar 2014 06:31:21 GMT

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

Mon, 24 Mar 2014 06:57:42 GMT

Hi all,

I've found the cause.

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

FYI.

Thu, 10 Apr 2014 14:52:02 GMT

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