Complex Stored Proc. and ADODC

Hi there people
Here is an interesting one:

I have a VB6 application and a SQL Server 6.5 Server.
I`m trying to execute a stored procedure using the ADODC - Control.
There is 2 stored procs on the DB:

CREATE PROCEDURE Display1 AS
BEGIN
      SELECT * FROM personnel
      where per_groupcode = 47
END

and

CREATE PROCEDURE Display2 AS
BEGIN
      SELECT *
      into #temp
      FROM personnel
      WHERE per_groupcode=47

      select * from #temp
END

and VB code like this:
Private Sub Command1_Click()
    With Adodc2
        .ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=marxr;Initial Catalog=klokdb;Data Source=drdsql2"
        .CommandType = adCmdStoredProc
        .RecordSource = "Display1"
        .UserName = "marxr"
        .Password = "xxxxxx"
        .Refresh
        List1.Clear
        With .Recordset
            .MoveFirst
            While .EOF = False
                List1.AddItem !per_name
                .MoveNext
            Wend
        End With
    End With
End Sub

Now that works just fine!!!!
but now if I substitute the stored proc. name with
   .RecordSource = "Display2"

the program generates the following error:
[Adodc2]
The operation requisted by the application is not allowed if the object is closed.
<Ok>

Any sugestions on why this is happenning and how to get it working with Display2?Start Free Trial