I am getting the following error while trying to read a recordset:


ADODB.Recordset(0X800A0E78)Operation is not allowed when the object is

closed.
The error happens in the following line after I execute a stored

procedure in SQLSERVER 7:

set rs=Server.CreateObject("ADODB.Recordset")
set cn=Server.CreateObject("ADODB.Connection")
set cmd=Server.CreateObject("ADODB.Command")

cn.connectionstring ="..."
cn.open

cmd.ActiveConnection=cn
cmd.CommandText="getXMLdata"
cmd.CommandType=4

word=CStr(Request.Form("txt1"))
rs.nocount=on
rs.Open "Exec getXMLdata'" & word &"'",cn

While Not rs.EOF <---------line of error!!!!!!
response.Write(rs(0) & "<br>")
rs.MoveNext
wend

rs.close
set rs=nothing


I do not know how to debug this problem.

Please help!!!!

arathy

hi there.. you are not opening a recordset, you are executing a SP inside the open of a recordset.. if you want to get the returning recordset, betteg use the execute of the connection.

HTH

Gonzalo