Stored Procedure doesn't generate recordset from temp table

[jluost1]

In my stored procedure, I insert values into a temporary table I created #tid_attrib_value.

At the end of the procedure, I call the following statement:

"SELECT * FROM #tid_attrib_value".

I can run this from Query Analyzer and get what I want. However, if I call it from ASP page, I get the error:

"The operation requested by the application is not allowed if the object is closed. "

I use the following line in ASP page:
set tempRS = sqlConn.Execute(q,,4)
where sqlConn is my connection object. q is a string of my stored procedure name and arguments.

I use this line to execute other PROC and it is working fine.

Any idea?

 

[tlbroadbent]

Possible solution: Add SET NOCOUNT ON to the beginning of your SP.

Reference:

http://support.microsoft.com/support/kb/articles/Q235/3/40.ASP

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.

 

[jluost1]

I did set NOCOUNT ON at the beginning of the PROC.