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.