FrontPage Server Extensions for Windows - FrontPage .asp form not populating Access database

This is Interesting: Free IT Magazines  
Home > Archive > FrontPage Server Extensions for Windows > March 2004 > FrontPage .asp form not populating Access database





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author FrontPage .asp form not populating Access database
Dave

2004-03-18, 1:57 pm

Hi,

We have two servers, a development server and a production server.
Supposedly, these two servers are to mirror each other exactly.
Anyway, on our development server, I've built an .asp form in FP2002,
then had FP2002 build an Access 2002 database from it using Form
Properties-->Send to database-->Options...-->Create Database...etc...
This worked great on our development server. I opened the .asp page in
IE, populated the form, clicked submit, and got my confirmation page.
When I checked the Results table in the Access 2002 db FP created for
me, the record was there.

I duplicated the same process on our production server, and everything
appeared to work correctly, however, the form data does not populate
the Access db. What should I check on the production server to
troubleshoot this? Is this a server extension issue? I looked at what
I thought was the folder for these server extensions on both servers,
and the files there appeared identical.

Thank you very much for any assistance provided,

Dave Brandes
dave_brandes@msn.com
Vijay R Gangolli [MSFT]

2004-03-20, 9:23 pm

Hi Dave,

1. Ensure the anonymous user has permissions to modify the access DB
2. Ensure the web site [with global.asa] that has the DB has been set to an
Application

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| From: dave_brandes@msn.com (Dave)
| Newsgroups: microsoft.public.frontpage.extensions.windowsnt
| Subject: FrontPage .asp form not populating Access database
| Date: 18 Mar 2004 09:19:23 -0800|
| Hi,
|
| We have two servers, a development server and a production server.
| Supposedly, these two servers are to mirror each other exactly.
| Anyway, on our development server, I've built an .asp form in FP2002,
| then had FP2002 build an Access 2002 database from it using Form
| Properties-->Send to database-->Options...-->Create Database...etc...
| This worked great on our development server. I opened the .asp page in
| IE, populated the form, clicked submit, and got my confirmation page.
| When I checked the Results table in the Access 2002 db FP created for
| me, the record was there.
|
| I duplicated the same process on our production server, and everything
| appeared to work correctly, however, the form data does not populate
| the Access db. What should I check on the production server to
| troubleshoot this? Is this a server extension issue? I looked at what
| I thought was the folder for these server extensions on both servers,
| and the files there appeared identical.
|
| Thank you very much for any assistance provided,
|
| Dave Brandes
| dave_brandes@msn.com
|

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com