SQL Server store procedure via OLEDB

csellei — Mon, 28 Jun 2010 22:01:42 GMT

Hi,

I'm trying to execute a SQL Server Store Procedure:

It works just fine via ODBC, but It doesn't work via OLEDB. I get no rows.

Any suggestions?

Here is the code:

CONNECT

TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Catalog;Data Source=SErver;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=IDWS;Use Encryption for Data=False;Tag with column collation when possible=False];

SQL

EXEC MySP;

Tanks in advance.

topic SQL Server store procedure via OLEDB in QlikView

SQL Server store procedure via OLEDB