title: "Operation is not allowed when the object is closed" when executing stored procedure
body: <p>This is my stored procedure, and when I am calling it from my classic ASP code, I am getting the error: </p>
  
  <blockquote>
    <p>Operation is not allowed when the object is closed.</p>
  </blockquote>
  
  <p>when I try to do a record count.</p>
  
  <p>Does anyone know what is wrong here?</p>
  
  <p>I am trying to return the table <code>@t</code>.</p>
  
  <p>Thanks.</p>
  
  <pre><code>USE [Hires_new]
  GO
  /****** Object:  StoredProcedure [dbo].[sp_selectNewHireWorkPeriodsSQL]    Script Date: 05/13/2013 14:04:12 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  -- =============================================
  -- Author:      
  -- Create date: 
  -- Description: 
  -- =============================================
  ALTER PROCEDURE [dbo].[sp_selectNewHireWorkPeriodsSQL] 
      -- Add the parameters for the stored procedure here
  
  AS
  
      declare @t table (HireID int, StartDate datetime, EndDate datetime, date_initiated datetime, date_closed datetime, firmName nvarchar(100), InquiryID int)
      DECLARE @acc INT 
      SET @acc = 1
      DECLARE @max INT 
      select @max = max(HireID) from NewHire
      WHILE (@acc &lt;= @max)
          BEGIN
              IF (@acc in (select HireID from NewHire))
                  BEGIN
                      insert into @t  
                          select HireID, StartDate, EndDate, date_initiated, date_closed, firmName, Inquiries.InquiryID 
                          from WorkPeriod, Firms, Inquiries 
                          where HireID = @acc and WorkPeriod.FirmID = Firms.FirmID and WorkPeriod.InquiryID = Inquiries.InquiryID 
                          order by HireID,StartDate DESC
                  END
              set @acc = @acc + 1
          END
      select * from @t
  </code></pre>
  
  <p>Asp classic code</p>
  
  <pre><code>selectNewHireWorkPeriodsSQL = "EXEC sp_selectNewHireWorkPeriodsSQL"
  Set rsNewHireWorkPeriods = Server.CreateObject("ADODB.Recordset")
  rsNewHireWorkPeriods.Open selectNewHireWorkPeriodsSQL,ConnectionString,adOpenStatic
  NumOfNewHireWorkPeriods = rsNewHireWorkPeriods.RecordCount
  
  response.write(NumOfNewHireWorkPeriods)
  </code></pre>