p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: What does this error mean? ADODB.Recordset error '800a0e78'


Message #1 by rrrabe@y... on Fri, 1 Dec 2000 10:38:37 -0000
Hello again everybody,



I would like to seek your expertise on how to resolve this thing.  I had

this error which states:



ADODB.Recordset error '800a0e78' 



The operation requested by the application is not allowed if the object is

closed



What does this error mean?



Again my gratitude in advance.



regards,

Bay

Message #2 by "Kart" <karthik1@h...> on Fri, 1 Dec 2000 17:13:10 +0530
Hi,



Please give us the SQL statement you are using, the way you are opening the

database connection, the way in which you are opening the recordset.



You will get better help with those details.



Kart





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

From: <rrrabe@y...>

To: ASP Databases <asp_databases@p...>

Sent: Friday, December 01, 2000 4:08 PM

Subject: [asp_databases] What does this error mean? ADODB.Recordset error

'800a0e78'





> Hello again everybody,

>

> I would like to seek your expertise on how to resolve this thing.  I had

> this error which states:

>

> ADODB.Recordset error '800a0e78'

>

> The operation requested by the application is not allowed if the object is

> closed

>

> What does this error mean?

>

> Again my gratitude in advance.

>

> regards,

> Bay

>

>





 

Message #3 by "Russell Peto" <russell@i...> on Fri, 1 Dec 2000 12:05:06 -0000
This error usually occurs if you have been running a query on a recordset

that automatically closes the recordset after it has been run, E.G. an

INSERT, UPDATE or DELETE query.

This can also happen if you have the statement " set (recordset) = nothing

" somewhere in your code.



To rectify this problem, simply re-create your recordset with another

query.



Hope this helps.

Message #4 by "Kart" <karthik1@h...> on Fri, 1 Dec 2000 17:24:49 +0530
OK I guess I didnt read your message fully before :-)



This problem could occur if -

you closed the connection or recordset object like this -



conn.close() or rs.close()



and then tried to use that object to fetch records from a DB.



Also, check if you have set the object to "nothing" and then are trying to

get the records from the DB.



Do tell me if it works out for you



Kart

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

From: <rrrabe@y...>

To: ASP Databases <asp_databases@p...>

Sent: Friday, December 01, 2000 4:08 PM

Subject: [asp_databases] What does this error mean? ADODB.Recordset error

'800a0e78'





> Hello again everybody,

>

> I would like to seek your expertise on how to resolve this thing.  I had

> this error which states:

>

> ADODB.Recordset error '800a0e78'

>

> The operation requested by the application is not allowed if the object is

> closed

>

> What does this error mean?

>

> Again my gratitude in advance.

>

> regards,

> Bay

>

>





 

Message #5 by Imar Spaanjaars <Imar@S...> on Fri, 01 Dec 2000 13:00:56 +0100
This means exactly what it says: you are not allowed to perform a certain 

operation on a closed recordset.

Suppose you open a recordset with the following code:



         rsRecordsetTest.Open sSQL, connConnection, adOpenForwardOnly, 

adLockReadOnly, adCmdText



Now you can do various things with this recordset. For instance ask for its 

.EOF property, or move to the next record.



if rsRecordsetTest.EOF then

         ' Empty recordset

else

         rsRecordsetTest.MoveNext

end if



No imagine that before you do this, you close the recordset (or never open 

it in the first place)



         rsRecordsetTest.Open sSQL, connConnection, adOpenForwardOnly, 

adLockReadOnly, adCmdText

         rsRecordsetTest.Close

         if rsRecordsetTest.EOF then ' will cause an error

                 ' Empty recordset

         else

                 rsRecordsetTest.MoveNext

         end if



This will generate your error in the line with "if rsRecordsetTest.EOF" 

because the recordset is closed.

If you send us some code, it'll be more clear where and why your error is 

caused.



Imar







At 10:38 AM 12/1/2000 +0000, you wrote:

>Hello again everybody,

>

>I would like to seek your expertise on how to resolve this thing.  I had

>this error which states:

>

>ADODB.Recordset error '800a0e78'

>

>The operation requested by the application is not allowed if the object is

>closed

>

>What does this error mean?

>

>Again my gratitude in advance.

>

>regards,

>Bay

>

Message #6 by "StephenB" <stephenb@w...> on Fri, 1 Dec 2000 12:26:02 -0000
Also from Robert Chartier in another question:



microsoft knowledge base



do this:



in IE, go to:

http://www.aspfree.com/devlinks/search.asp?file404=;&catid=23



click, and drag the item "M$ Knowledge Base"  #21

on to the "links" bar in your internet explorer......Hit YES



now when you want to search anything in the knowledge base, you can just

hit that button, type in your crieteria (c004800a) and hit ok.  Instant

access into the KB.



All of the links at the above URL behave that way.  So add in the

Developers Resource, the dictionary, or any other engine that I have setup.



good luck.



I think I'll add this to the ASP FAQ at http://p2p.wrox.com/ .



Stephen



<rrrabe@y...> wrote in message news:22155@a..._databases...

>

> Hello again everybody,

>

> I would like to seek your expertise on how to resolve this thing.  I had

> this error which states:

>

> ADODB.Recordset error '800a0e78'

>

> The operation requested by the application is not allowed if the object is

> closed

>

> What does this error mean?

>

> Again my gratitude in advance.

>

> regards,

> Bay

>

>





Message #7 by Stephane_Dattenny@D... on Fri, 1 Dec 2000 06:34:04 -0600
Hi 



What's your code please ?



Best regards / Cordialement

 

Stephane Dattenny

Dell Computers - EMEA IT - VB and Web developer

Phone: +33 (0)4 99 75 49 88 



 





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

From: rrrabe@y... [mailto:rrrabe@y...]

Sent: 01 December 2000 11:39

To: ASP Databases

Subject: [asp_databases] What does this error mean? ADODB.Recordset

error '800a0e78'





Hello again everybody,



I would like to seek your expertise on how to resolve this thing.  I had

this error which states:



ADODB.Recordset error '800a0e78' 



The operation requested by the application is not allowed if the object is

closed



What does this error mean?



Again my gratitude in advance.



regards,

Bay



Message #8 by "Dallas Martin" <dmartin@z...> on Fri, 1 Dec 2000 09:52:06 -0500
It means the recordset is closed.

Do a find on your code for the word "close"



If found, look at your code and make corrections.



If not found, do a find on your code for every

mentioned of the recordset object name.



Check to see if you have instantiated it  and opened

it in your code.



Check to see if you have previously closed the connection

object asssociated with the recordset before you use the

recordset object. If so then remove that part of the code.



I've been there and done that!!!



hth



Dallas Martin

















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

From: <rrrabe@y...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, December 01, 2000 5:38 AM

Subject: [asp_databases] What does this error mean? ADODB.Recordset error

'800a0e78'





> Hello again everybody,

>

> I would like to seek your expertise on how to resolve this thing.  I had

> this error which states:

>

> ADODB.Recordset error '800a0e78'

>

> The operation requested by the application is not allowed if the object is

> closed

>

> What does this error mean?

>

> Again my gratitude in advance.

>

> regards,

> Bay

>



Message #9 by Robert Chartier <rchartierh@a...> on Fri, 01 Dec 2000 11:13:01 -0500
it means your query returned NO data, thus the recordset is probably not 

open, thus you cannot do any work with it.



you can check:



objRS.state

objRs.eof



etc..







At 06:43 AM 12/1/00, you wrote:

>Hi,

>

>Please give us the SQL statement you are using, the way you are opening the

>database connection, the way in which you are opening the recordset.

>

>You will get better help with those details.

>

>Kart

>

>

>----- Original Message -----

>From: <rrrabe@y...>

>To: ASP Databases <asp_databases@p...>

>Sent: Friday, December 01, 2000 4:08 PM

>Subject: [asp_databases] What does this error mean? ADODB.Recordset error

>'800a0e78'

>

>

> > Hello again everybody,

> >

> > I would like to seek your expertise on how to resolve this thing.  I had

> > this error which states:

> >

> > ADODB.Recordset error '800a0e78'

> >

> > The operation requested by the application is not allowed if the object is

> > closed

> >

> > What does this error mean?

> >

> > Again my gratitude in advance.

> >

> > regards,

> > Bay

> >

> >

>

>

>

>



Robert Chartier

Author, AspFree.com

xxx-xxx-xxxx

rchartierh@a...

http://www.aspfree.com/devlinks

http://www.aspfree.com/authors/robert

http://www.aspalliance.com/nothingmn



Message #10 by "jigs gandhi" <newsgroup@h...> on Sat, 2 Dec 2000 08:52:55 +0530
This is a multi-part message in MIME format.



------=_NextPart_000_011E_01C05C3D.43417E60

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



hi,



Please check if you have used a proper

RecordSet.Open command

OR

set RecordSet =3D Connection.Execute(something)



jigs

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

  From: rrrabe@y...

  To: ASP Databases

  Sent: Friday, December 01, 2000 4:08 PM

  Subject: [asp_databases] What does this error mean? ADODB.Recordset 

error '800a0e78'





  Hello again everybody,



  I would like to seek your expertise on how to resolve this thing.  I 

had

  this error which states:



  ADODB.Recordset error '800a0e78'



  The operation requested by the application is not allowed if the 

object is

  closed



  What does this error mean?



  Again my gratitude in advance.



  regards,

  Bay



  ---

  FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

  INSIGHTS IN YOUR INBOX!

  Get the latest and best C++, Visual C++, Java, Visual Basic, and XML 

tips, tools, and

  developments from the experts.  Sign up for one or more of EarthWeb?s

  FREE IT newsletters at http://www.earthweb.com today! 




$subst('Email.Unsub')










Message #11 by rrrabe@y... on Mon, 4 Dec 2000 13:15:20 -0000
Hello Robert,



Thank you.  thank you!  Problem solved!



I had set 2 recordset on which one is sitting idle. I had already removed

it and viola!



merci beaucoup!

Bay

Message #12 by Robert Chartier <rchartierh@a...> on Fri, 01 Dec 2000 11:13:01 -0500
it means your query returned NO data, thus the recordset is probably not 

open, thus you cannot do any work with it.



you can check:



objRS.state

objRs.eof



etc..







At 06:43 AM 12/1/00, you wrote:

>Hi,

>

>Please give us the SQL statement you are using, the way you are opening the

>database connection, the way in which you are opening the recordset.

>

>You will get better help with those details.

>

>Kart

>

>

>----- Original Message -----

>From: <rrrabe@y...>

>To: ASP Databases <asp_databases@p...>

>Sent: Friday, December 01, 2000 4:08 PM

>Subject: [asp_databases] What does this error mean? ADODB.Recordset error

>'800a0e78'

>

>

> > Hello again everybody,

> >

> > I would like to seek your expertise on how to resolve this thing.  I had

> > this error which states:

> >

> > ADODB.Recordset error '800a0e78'

> >

> > The operation requested by the application is not allowed if the object is

> > closed

> >

> > What does this error mean?

> >

> > Again my gratitude in advance.

> >

> > regards,

> > Bay

> >

> >

>

>

>

>



Robert Chartier

Author, AspFree.com

xxx-xxx-xxxx

rchartierh@a...

http://www.aspfree.com/devlinks

http://www.aspfree.com/authors/robert

http://www.aspalliance.com/nothingmn





---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  






Message #13 by "jigs gandhi" <newsgroup@h...> on Sat, 2 Dec 2000 08:52:55 +0530
This is a multi-part message in MIME format.



------=_NextPart_000_011E_01C05C3D.43417E60

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



hi,



Please check if you have used a proper

RecordSet.Open command

OR

set RecordSet =3D Connection.Execute(something)



jigs

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

  From: rrrabe@y...

  To: ASP Databases

  Sent: Friday, December 01, 2000 4:08 PM

  Subject: [asp_databases] What does this error mean? ADODB.Recordset 

error '800a0e78'





  Hello again everybody,



  I would like to seek your expertise on how to resolve this thing.  I 

had

  this error which states:



  ADODB.Recordset error '800a0e78'



  The operation requested by the application is not allowed if the 

object is

  closed



  What does this error mean?



  Again my gratitude in advance.



  regards,

  Bay



  ---

  FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

  INSIGHTS IN YOUR INBOX!

  Get the latest and best C++, Visual C++, Java, Visual Basic, and XML 

tips, tools, and

  developments from the experts.  Sign up for one or more of EarthWeb?s

  FREE IT newsletters at http://www.earthweb.com today! 




$subst('Email.Unsub')









--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.













Message #14 by "jigs gandhi" <newsgroup@h...> on Sat, 2 Dec 2000 08:52:55 +0530
This is a multi-part message in MIME format.



------=_NextPart_000_011E_01C05C3D.43417E60

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



hi,



Please check if you have used a proper

RecordSet.Open command

OR

set RecordSet =3D Connection.Execute(something)



jigs

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

  From: rrrabe@y...

  To: ASP Databases

  Sent: Friday, December 01, 2000 4:08 PM

  Subject: [asp_databases] What does this error mean? ADODB.Recordset 

error '800a0e78'





  Hello again everybody,



  I would like to seek your expertise on how to resolve this thing.  I 

had

  this error which states:



  ADODB.Recordset error '800a0e78'



  The operation requested by the application is not allowed if the 

object is

  closed



  What does this error mean?



  Again my gratitude in advance.



  regards,

  Bay



  ---

  FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

  INSIGHTS IN YOUR INBOX!

  Get the latest and best C++, Visual C++, Java, Visual Basic, and XML 

tips, tools, and

  developments from the experts.  Sign up for one or more of EarthWeb?s

  FREE IT newsletters at http://www.earthweb.com today! 




$subst('Email.Unsub')









--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.













Message #15 by Stephane_Dattenny@D... on Fri, 1 Dec 2000 06:34:04 -0600
Hi 



What's your code please ?



Best regards / Cordialement

 

Stephane Dattenny

Dell Computers - EMEA IT - VB and Web developer

Phone: +33 (0)4 99 75 49 88 



 





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

From: rrrabe@y... [mailto:rrrabe@y...]

Sent: 01 December 2000 11:39

To: ASP Databases

Subject: [asp_databases] What does this error mean? ADODB.Recordset

error '800a0e78'





Hello again everybody,



I would like to seek your expertise on how to resolve this thing.  I had

this error which states:



ADODB.Recordset error '800a0e78' 



The operation requested by the application is not allowed if the object is

closed



What does this error mean?



Again my gratitude in advance.



regards,

Bay





---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  






Message #16 by "StephenB" <stephenb@w...> on Fri, 1 Dec 2000 12:26:02 -0000
Also from Robert Chartier in another question:



microsoft knowledge base



do this:



in IE, go to:

http://www.aspfree.com/devlinks/search.asp?file404=;&catid=23



click, and drag the item "M$ Knowledge Base"  #21

on to the "links" bar in your internet explorer......Hit YES



now when you want to search anything in the knowledge base, you can just

hit that button, type in your crieteria (c004800a) and hit ok.  Instant

access into the KB.



All of the links at the above URL behave that way.  So add in the

Developers Resource, the dictionary, or any other engine that I have setup.



good luck.



I think I'll add this to the ASP FAQ at http://p2p.wrox.com/ .



Stephen



<rrrabe@y...> wrote in message news:22155@a..._databases...

>

> Hello again everybody,

>

> I would like to seek your expertise on how to resolve this thing.  I had

> this error which states:

>

> ADODB.Recordset error '800a0e78'

>

> The operation requested by the application is not allowed if the object is

> closed

>

> What does this error mean?

>

> Again my gratitude in advance.

>

> regards,

> Bay

>

>







--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  






Message #17 by "Dallas Martin" <dmartin@z...> on Fri, 1 Dec 2000 09:52:06 -0500
It means the recordset is closed.

Do a find on your code for the word "close"



If found, look at your code and make corrections.



If not found, do a find on your code for every

mentioned of the recordset object name.



Check to see if you have instantiated it  and opened

it in your code.



Check to see if you have previously closed the connection

object asssociated with the recordset before you use the

recordset object. If so then remove that part of the code.



I've been there and done that!!!



hth



Dallas Martin

















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

From: <rrrabe@y...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, December 01, 2000 5:38 AM

Subject: [asp_databases] What does this error mean? ADODB.Recordset error

'800a0e78'





> Hello again everybody,

>

> I would like to seek your expertise on how to resolve this thing.  I had

> this error which states:

>

> ADODB.Recordset error '800a0e78'

>

> The operation requested by the application is not allowed if the object is

> closed

>

> What does this error mean?

>

> Again my gratitude in advance.

>

> regards,

> Bay

>





--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  







  Return to Index