Get Recordset Data From SQL 2005 In ASP

Dear All,

I hope someone can help me in this problem. I create the Procedure to generate the dynamic SQL statement, and execute the dynamic SQL at end of the Procedure. When I done in Server Management Studio, all thing is OK, return me the record.

But when i use it in ASP, the statement as below





Code Block
Dim objCmd
Set objCmd = Server.CreateObject("ADODB.Command")
With objCmd
set .ActiveConnection = objCn
.CommandText = "MyProcedure"
.CommandType = 4
.Parameters.Append = .CreateParameter("@Par1", 200, 1, 10, Par1)
.Parameters.Append = .CreateParameter("@Par2", 200, 1, 8, Par2)
.Parameters.Append = .CreateParameter("@Par3", 200, 1, 1, Par3)

Set objRs = .Execute ()

If Not objRs.EOF Then
ID = objRs.Fields.Item (0).value
Name = objRs.Fields.Item (1).value
End If
objRs.close
End With

set ObjCmd = nothing






The Error below display, Why??




Code BlockError Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.



And this is work fine in SQL 2000 before