Unable to Update Database Records

[Chad_Nichols]

Sympton: The server has been performing adds, updates, deletes without any
problems (for at least a year now). As of last night all ASP pages that
perform the UPDATE statement stopped functioning. INSERT and SELECT
statements continue functioning normally. Nothing changed with the code and
the server administrator swears no changes were made on the server-end
(unless there was one of those "silent" Windows Updates, he admits. This is
the error message:

"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."

Environment: Windows 2003 Server, Web Edition; FrontPage 2003 connecting to
an MS Access database

These are the steps I've taken to try and troubleshoot the problem:

1) Published the entire website to a Windows 2000 Server and the problem
persists, which tells me it is likely not OS-specific
2) Changed the Connection from the internal FrontPage database connection to
an ODBC driver as a system DSN, no change & same symptons
3) I went to the extreme and changed permissions for the IUSR account in the
/fpdb folder to "full" just to ensure that had nothing to do with it, no
change
4) I restored from a known-working Access database backup from 4 weeks ago,
no change
5) Every article at MS Support Site that I could find with the mentioned
error does not pertain, although I went through each one just to verify it
didn't apply (Articles 828898, 828905, 891819, 898721)
6) On the SAME server where this sympton occurs there is another website I
manage that is setup similarly (meaning Access database), and is functioning
normally (meaning you can perform INSERT, UPDATE, DELETE without problems)

Any ideas? 12 hours after banging my head against the wall, well, I'm at a
complete loss. Thx, Chad.

 

[News]

Hi Chad,
I'm afraid i cannot help you but maybe You can help me,
I'm having problems with the INSERT statement and keep getting the
same error as you have with the UPDATE statement.
Do you use "custom-query" in DBRW, and if so can/will you show me what
the sql-string looks like when using the INSERT statement. (can't seem to
get it working)
Thanks in advance,
Arthur

 

[Chad_Nichols]

Hi Arthur. No, I'm using DBRW for SELECT and UPDATE statements, not INSERT
statements. Rather than using an INSERT query I'm using forms and passing the
data via "options" within "form properties."

Would still love to hear from anyone with ideas on my issue??? Thx, Chad.

Chad Nichols
=========
(e-mail address removed)

 

[Chad_Nichols]

To Anyone Else Experiencing this Problem:

My troubleshooting led to the fact that the problem was within the website
itself, since the problem was replicated on another server where I restored
the data and started with a brand new MySQL database (not Access). This told
me the problem was definitely within the FrontPage processing itself,
somewhere in the website.

I found the problem in the _fpclass hidden folder. I found 4 files ending in
*.inc (fpdbform.inc, fpdblib.inc, fpdbrgn1.inc, & fpdbrgn2.inc) and replaced
the files on the server with these same files, but from FrontPage 2002 ---
this FIXED the problem 100%. Very weird problem. Unsure whether this is a
backwards-compatibility issue between FP2K3 and FP2K, but regardless, it's a
problem. Hope this post helps save someone else tons of time, since it took
me so long to figure it out. Regards to all! Chad.

Chad Nichols
========
(e-mail address removed)