Database Results Wizards Error

[lsijax]

I am using FP03, Server2003, IIS6 and 2002 FPSE. I uploaded an Access db,
created and tested a valid connection and then ran the wizard creating
ASP.Net pages. I am able to browse the files in the db from the Results and
Editor pages, but I am unable to add, delete or modify the records. I get
the generic error - “The operation failed. If this continues, please contact
your server administrator.†I am the admin for this server and the RWD
permissions are in place. Any help would be appreciated.

Thanks

 

[Jim Buyens]

To plug some security holes, Microsoft applied service pack
changes to FrontPage 2002 (and carried them over to FrontPage
2003) that inadvertently interfered with the use of INSERT, UPDATE,
and DELETE statements in the ASP version of the Database Results Wizard.

The files affected are FPDBRGN1.inc, FPDBRGN2.inc, and FPDBLIB.inc.
The contain model statements that FrontPage converts to
FPDBRGN1.inc, FPDBRGN2.inc, and FPDBLIB.inc the first time you run
the DRW in a Web site. So, one fix (although a poor one) is to get
the FP2000 or original FP2002 (non-service pack) version of these
files. The problem with this, of course, is that you re-introduce
the security holes.

As a result, you'll probably have greater success using the ASP.NET
version of the DRW, or writing your own ASP code.

Writing your own ASP code for inserting records isn't
difficult. Try the advice at:

Saving Form Data in a Database
http://www.interlacken.com/win­nt/tips/tipshow.aspx?tip=44

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------