stored procedure does not return any records

G

George LAZAR

Hello!

I have an ADP project, MsAccess 2000 and MS Sql server 2000.
I have a sored procedure that is using temporary tables. In query analyzer
it returns recordsets, but when calling the same sored procedure (with the
same parameter) from access it does not returns any records.

any ideea?
thank you


George LAZAR
 
G

Guest

Put
set nocount on as prior to any sql statement that returns
counts or recordset/cursors.
Then add SET NOCOUNT OFF just before the statement to
return your record set.
 
Top