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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
'The stored procedure executed successfully but did not return any records' 4
adp report does not recognize fields from stored procedure 3
Stored Procedure temp table not returning any results in an ADP 3
The stored procedure executed successfully but did not return anyrecords 1
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Running a Stored Procedure Using a Form Event 5
Returning values from temporary table in stored procedure 2

Top