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

Shiller wrote:
On Feb 21, 1:48 pm, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx>
wrote:
Shiller wrote:
Experts,

I'm running a web application with Microsoft Access as my backend
database.

when I call a stored procedure from ASP I get the the following
error message:

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

Has anyone else encounter this error message when running Access as
web database, if yes please help.

This message is not dependant on the backend database. It's caused by
trying to do something that is not allowed. Exactly what that is in
your case is impossible for us to tell. Show us your code ... just
the relevant portion please: we don't need to see a bunch of html ...

The error message is pointing to this line of code:

*****
If Not IsEmpty(mCountSQL) And Len(CountSQL) = 0 And NOT
DataSource.Recordset.EOF Then
*****


Well, it looks to me as if you are trying to check the EOF property of a
closed recordset. Looking in your code I see that this line is followed
by:
If DataSource.Recordset.State = adStateOpen Then

It seems to me that you should be doing this BEFORE checking EOF ...



--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • RE: SHAREPOINT and mssql$sharepoint
    ... The error in the event viewere ... Check the database connection information and make ... > Thank you for posting in SBS newsgroup. ... > You may post error message and the event log which you have changed your ...
    (microsoft.public.windows.server.sbs)
  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)
  • Re: Module Not Found
    ... Close the database. ... Still in the code window, choose Compile from the Debug menu. ... The error message could be related to something else that is going on, ... VB and press the cancel button I receive the error message ...
    (microsoft.public.access.formscoding)
  • Re: Cannot open my own Databases
    ... Windows Administrator and loads each of these service packs. ... If I have guessed correctly about the error message you see, ... See http://www.QBuilt.com for all your database needs. ... it's possible that the correct workgroup information file ...
    (microsoft.public.access.security)
  • RE: Form loading error
    ... Compact and repair your database; ... I just noticed that I get the same error message when I close the ... An error occured while loading Form_FrmXYZ. ... This Form (XYZ) is not the switchboard nor is it set to auto open. ...
    (microsoft.public.access.formscoding)