using asp script to retrieve data from sql stored proceedure 1

[ToddF]

when retieving data from sql db using asp script on a web page, I can use a stored procedure with no problem until I use a temp table in the stored procedure. If I do this I get an asp error noting the data source is closed.

Any ideas on how to make this work?

 

[tlbroadbent]

Make sue you include the following line at the start of the stored procedure. It will inhibit the generation of ROWS AFFECTED messages when inserting into the temp table. Those messages can cause problems in ADO connections.

SET NOCOUNT ON If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm