Hi Steve,

Yes I tried with



AdoCmd.Execute

Response.Write AdoCmd("Colname")



and I see it does return data from database. However, if more than one 

row

is returned how will I get them.

Thanks!

Salman







                                                                       

                           

                    Steve Carter                                       

                           

                    <Steve.Carter@t...       To:     "ASP Databases

"                          

                    tners.com>                    <asp_databases@p...

ox.com>                    

                                                 cc:                   

                           

                    08/17/01 05:45 AM            Subject:     [asp_data

bases] RE:                 

                    Please respond to "ASP        ADODB.Recordset(0X800

A0E78) ---HELP!!!          

                    Databases"                                         

                           

                                                                       

                           

                                                                       

                           









does sp_Logon return rows?  If not, then change



 Set rs =3D AdoCmd.Execute



to



 AdoCmd.Execute



and delete



 While not rs.EOF   <----- Line of error!!!!!!!!!!!



    do something.........



 Wend



HTH



Steve.



> > 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 DataConn =3D Server.CreateObject("ADODB.Connection")

> >

> >     DataConn.Open "DSN=3DLapDomA;uid=3DBrain;pwd=3DBrain"

> >

> >     SET AdoCmd =3D Server.CreateObject("ADODB.Command")

> >

> >     SET AdoCmd.ActiveConnection =3D DataConn

> >

> >     AdoCmd.CommandType =3D adCmdStoredProc

> >

> >     AdoCmd.CommandText =3D "sp_Logon"

> >

> >     AdoCmd.Parameters.Append AdoCmd.CreateParameter

> > ("Return",adInteger,adParamReturnValue,4)

> >

> >     AdoCmd.Parameters.Append AdoCmd.CreateParameter("User

> > name",adVarChar,adParmInput,50,Request.Form("User Name"))

> >                      AdoCmd.Parameters.Append AdoCmd.CreateParamete

r

> > ("Password",adVarChar,adParmInput,50,Request.Form("Password"))

> >

> >     Set rs =3D AdoCmd.Execute

> >

> > While not rs.EOF   <----- Line of error!!!!!!!!!!!

> >

> >    do something.........

> >

> > Wend