[thelist] callingm sql stored proc using asp

[Brian Delaney]

I am calling a stored proc on my sql server from asp.

For some reason if I call this sp sp_returnwhosnew I get the error
"that this operation not allowed when the object is closed"

here is the asp:

<%

Call OpenJailDivConn()

sDate = FormatDateTime(now, 2)

Set rsJailDiv = Server.CreateObject("ADODB.Recordset")
strSQL = "sp_returnwhosnewtest "
rsJailDiv.Open strSQL, JailDivConn
iCtr = 0
DIM varlname
DIM var
If NOT rsJailDiv.EOF Then
    while not rsJailDiv.EOF
etc. etc.

If I changed the strSQL to any other sp it works fine.

The SP uses a ##TEMP table and also calls a user defined function that 
does date manipulation. Is this the problem?

Any help will be appreciated.



*
*
*
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or priveleged information.  Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.