p2p.wrox.com: Archives - asp_ado

asp_ado_rds thread: ADODB.Recordset(0X800A0E78) Help!!!

Message #1 by Salman.Ahmed@r... on Sun, 16 Sep 2001 10:07:58 -0400

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



    DataConn.Open "DSN=LapDomA;uid=Brain;pwd=Brain"



    SET AdoCmd = Server.CreateObject("ADODB.Command")



    SET AdoCmd.ActiveConnection = DataConn



    AdoCmd.CommandType = adCmdStoredProc



    AdoCmd.CommandText = "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.CreateParameter

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



    Set rs = AdoCmd.Execute



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



   do something.........



Wend



I do not know how to debug this problem.

Please help!!!!

Salman

Message #2 by Josh King <JoshK@g...> on Thu, 16 Aug 2001 09:57:01 -0500

First of all make sure the stored procedure is returning a recordset. If

it's not then you'll have to check the state of the recorset before trying

to use it.   If it is then see if the procedure is doing any inserting or

updating into temp tables or any other data.  If it is then Set NoCount On.





Josh King



-----Original Message-----

From: Salman.Ahmed@r... [mailto:Salman.Ahmed@r...]

Sent: Sunday, September 16, 2001 9:08 AM

To: ASP_ADO_RDS

Cc: asp_ado_rds@p...

Subject: [asp_ado_rds] ADODB.Recordset(0X800A0E78) Help!!!



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



    DataConn.Open "DSN=LapDomA;uid=Brain;pwd=Brain"



    SET AdoCmd = Server.CreateObject("ADODB.Command")



    SET AdoCmd.ActiveConnection = DataConn



    AdoCmd.CommandType = adCmdStoredProc



    AdoCmd.CommandText = "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.CreateParameter

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



    Set rs = AdoCmd.Execute



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



   do something.........



Wend



I do not know how to debug this problem.

Please help!!!!

Salman

Message #3 by "Mohammed Abdul Azeem" <abdulazeem_it@h...> on Fri, 17 Aug 2001 11:09:44 +0000

Hi salman

I am also facing same problem if u got any solution pls tell me.



Azeem.











>From: Salman.Ahmed@r...

>Reply-To: "ASP_ADO_RDS" <asp_ado_rds@p...>

>To: "ASP_ADO_RDS" <asp_ado_rds@p...>

>CC: asp_ado_rds@p...

>Subject: [asp_ado_rds] ADODB.Recordset(0X800A0E78) Help!!!

>Date: Sun, 16 Sep 2001 10:07:58 -0400

>

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

>

>     DataConn.Open "DSN=LapDomA;uid=Brain;pwd=Brain"

>

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

>

>     SET AdoCmd.ActiveConnection = DataConn

>

>     AdoCmd.CommandType = adCmdStoredProc

>

>     AdoCmd.CommandText = "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.CreateParameter

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

>

>     Set rs = AdoCmd.Execute

>

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

>

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

>

>Wend

>

>I do not know how to debug this problem.

>Please help!!!!

>Salman

Return to Index

P2P Archives