Help with 'Either BOF or EOF is True..', etc
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=23329
Printed Date: 29 March 2026 at 10:50am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Help with 'Either BOF or EOF is True..', etc
Posted By: rokjo
Subject: Help with 'Either BOF or EOF is True..', etc
Date Posted: 14 May 2007 at 7:52am
Hi,
I have an asp site with msaccess db working beautifully under windows locally, however when I upload to a hosted site everything works login, view data, etc except adding records. I get the following error:
Either BOF or EOF is True, or the current record has been deleted.
and no record is added.
I've read the relevant tutorial on this site and can see that this error may occur if there are no records to retrieve - but I'm adding records. Could this be permissions? Someone also said that msaccess db's need to be zipped to ftp them and then unzipped on the server, tried to 'unarchive' the file on the host to no avail.
Anyone got a clue? PS I didn't write the ASP, just designed the db so go easy on the code jargon as I'm an aspsimpleton!
rokjo
|
Replies:
Posted By: pmormr
Date Posted: 24 May 2007 at 2:16am
(It's been a long time since I've coded ASP). If I remember correctly this has something to do with connection permissions. Try setting the connection.mode property to 3. See this page for the full details: http://www.w3schools.com/ado/prop_conn_mode.asp.
-------------
Paul A Morgan
http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/
|
Posted By: rokjo
Date Posted: 24 May 2007 at 3:50am
Hi,
Thanks for the input. Appears it was a permissions issue that was resolved by the third party host - think it relates to the db file itself.
Rokjo
|
|