No information is written from the ASP form to the Access database

[Russ]

Hi,

I am running IIS 5.1 on an XP Pro SP2 box.

I have created an asp form in FP2003 (that can be viewed at
http://www.rilinterface.com/cootnest/cootforms/PhotoRequestForm.asp).

I linked the form to an Access database (created by rt click on form region
(in FP design view) > Form Properties > Options > etc

Verified the field mapping between the form and the db
Updated the database (in options)

Although I get a success page on clicking “Submit,†I cannot get any data to
post from my form to Access

I’ve tried KB Article 31440 http://support.microsoft.com/kb/314440/en-us
I can monkey with “On Error Resume Next†in Fpdbform.inc and get a
submission failure page to show up.

I have been wading through FrontPage/ASP/Access tutorials and blogs all over
the web

I am now completely circular on this problem.

Any recommendations?

Thanks!

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Russ:
One thing you might want to check is that your table name and field names
have no spaces or special characters
http://support.microsoft.com/?id=826763 in them, and are not reserved words:

http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
http://support.microsoft.com/?id=321266


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

 

[Russ]

Hi Kathleen,

I took a look at each of those KB articles and didn’t find any special
characters, but sure enough I found a reserved word; I had a field named
“description.â€

Unfortunately, my problem persists.

I have set up a single field form (using default settings) at the parent
level subweb directory. http://rilinterface.com/cootnest/testform01.asp

As you should see (if you try the form) I get a “cannot open databaseâ€
results page.

In desperation, I tried to repro this by building the same form at work on a
Win03 Server Box running IIS 6 and it worked fine in the wwwroot directory,
but no where else.

One of the things that I did notice was that the web sharing settings on my
Win03 Server were on and they are not at the subweb directory on my Windows
XP Pro box. When I try to enable web sharing with the default directory name
(cootnest), I get the following message.

The alias “/LM/SMFTPSVC/1/ROOT/cootnest†already exists, please coos a
different alias

I found reference to this virtual directory path at
https://www.microsoft.com/windows20...indows2000/en/server/iis/htm/asp/aore0ard.htm

So, in the IIS management console, I created a virtual directory with the
alias “cootnest†and browsed to the same folder that gave me the alias error
above. That seemed to take. Now the Web sharing properties for the
“cootnest†directory are showing that web sharing is enabled with “readâ€
access permissions and “scripts†application permissions.


Finally, I went through each directory level in the IIS management console
and rant he permissions wizard to reset each level’s permissions to “public
web site†defaults.

Unfortunately nothing is working any differently/better.

Does any of this offer any clues?

I’m getting ready to try sprinkling voodoo dust on this apparatus.

- Russ

 

[Russ]

I have made no changes to anything since my last posting, but now, when I
test the form at
http://rilinterface.com/cootnest/testform01.asp
On Submit, nothing is written to the database, but it returns the following
message:
+++++++++++
Form Confirmation
Thank you for submitting the following information:
T1: blah
B1: Submit
Return to the form.
+++++++++++