ASP page not saving to DB

Followed FrontPage wizard to create online submission form. Pages were
generated automatically. Page coding appears to be correct. DB was also
generated by FrontPage.

The server is utilizing ODBC for the Access DB

Although I can view the pages remotely and I receive a confirmation that
information has been submitted, the database remains empty.

Any idea about why the "save to database" process is failing?

Dave

Re: ASP page not saving to DB

One common cause of that, is you may have inadvertently used a reserved name
in your column naming.
As the DRW uses "ON ERROR RESUME NEXT" it may not flag up your error and the
insert fails.



"H8ids" wrote in message
news:uesZLZEwEHA.3416@TK2MSFTNGP09.phx.gbl...
> Followed FrontPage wizard to create online submission form. Pages were
> generated automatically. Page coding appears to be correct. DB was also
> generated by FrontPage.
>
> The server is utilizing ODBC for the Access DB
>
> Although I can view the pages remotely and I receive a confirmation that
> information has been submitted, the database remains empty.
>
> Any idea about why the "save to database" process is failing?
>
> Dave
>
>

Re: ASP page not saving to DB

What does DRW mean.
I understand what you mean by reserved name; is there an available list of
reserve names? (Using Win 2000 Server, Access 2000 and ASP)

Thanks Dave



"dave" wrote in message
news:%23jytlhEwEHA.2944@TK2MSFTNGP12.phx.gbl...
> One common cause of that, is you may have inadvertently used a reserved
> name
> in your column naming.
> As the DRW uses "ON ERROR RESUME NEXT" it may not flag up your error and
> the
> insert fails.
>
>
>
> "H8ids" wrote in message
> news:uesZLZEwEHA.3416@TK2MSFTNGP09.phx.gbl...
>> Followed FrontPage wizard to create online submission form. Pages were
>> generated automatically. Page coding appears to be correct. DB was also
>> generated by FrontPage.
>>
>> The server is utilizing ODBC for the Access DB
>>
>> Although I can view the pages remotely and I receive a confirmation that
>> information has been submitted, the database remains empty.
>>
>> Any idea about why the "save to database" process is failing?
>>
>> Dave
>>
>>
>
>

Re: ASP page not saving to DB

http://www.aspfaq.com/show.asp?id=2080

H8ids wrote:
> What does DRW mean.
> I understand what you mean by reserved name; is there an available
> list of reserve names? (Using Win 2000 Server, Access 2000 and ASP)
>
> Thanks Dave
>
>
>
> "dave" wrote in message
> news:%23jytlhEwEHA.2944@TK2MSFTNGP12.phx.gbl...
>> One common cause of that, is you may have inadvertently used a
>> reserved name
>> in your column naming.
>> As the DRW uses "ON ERROR RESUME NEXT" it may not flag up your error
>> and the
>> insert fails.
>>
>>
>>
>> "H8ids" wrote in message
>> news:uesZLZEwEHA.3416@TK2MSFTNGP09.phx.gbl...
>>> Followed FrontPage wizard to create online submission form. Pages
>>> were generated automatically. Page coding appears to be correct. DB
>>> was also generated by FrontPage.
>>>
>>> The server is utilizing ODBC for the Access DB
>>>
>>> Although I can view the pages remotely and I receive a confirmation
>>> that information has been submitted, the database remains empty.
>>>
>>> Any idea about why the "save to database" process is failing?
>>>
>>> Dave

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: ASP page not saving to DB

The "DRW" is the name of the database results/region wizard that you have
used from frontpage


"H8ids" wrote in message
news:ONACkFFwEHA.3108@TK2MSFTNGP14.phx.gbl...
> What does DRW mean.
> I understand what you mean by reserved name; is there an available list of
> reserve names? (Using Win 2000 Server, Access 2000 and ASP)
>
> Thanks Dave
>
>
>
> "dave" wrote in message
> news:%23jytlhEwEHA.2944@TK2MSFTNGP12.phx.gbl...
> > One common cause of that, is you may have inadvertently used a reserved
> > name
> > in your column naming.
> > As the DRW uses "ON ERROR RESUME NEXT" it may not flag up your error and
> > the
> > insert fails.
> >
> >
> >
> > "H8ids" wrote in message
> > news:uesZLZEwEHA.3416@TK2MSFTNGP09.phx.gbl...
> >> Followed FrontPage wizard to create online submission form. Pages were
> >> generated automatically. Page coding appears to be correct. DB was also
> >> generated by FrontPage.
> >>
> >> The server is utilizing ODBC for the Access DB
> >>
> >> Although I can view the pages remotely and I receive a confirmation
that
> >> information has been submitted, the database remains empty.
> >>
> >> Any idea about why the "save to database" process is failing?
> >>
> >> Dave
> >>
> >>
> >
> >
>
>

Re: ASP page not saving to DB

Thanks. Appears as though I have a lot of re-coding ahead. :(

Dave


"Bob Barrows [MVP]" wrote in message
news:OEihCmFwEHA.2540@TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/show.asp?id=2080
>
> H8ids wrote:
>> What does DRW mean.
>> I understand what you mean by reserved name; is there an available
>> list of reserve names? (Using Win 2000 Server, Access 2000 and ASP)
>>
>> Thanks Dave
>>
>>
>>
>> "dave" wrote in message
>> news:%23jytlhEwEHA.2944@TK2MSFTNGP12.phx.gbl...
>>> One common cause of that, is you may have inadvertently used a
>>> reserved name
>>> in your column naming.
>>> As the DRW uses "ON ERROR RESUME NEXT" it may not flag up your error
>>> and the
>>> insert fails.
>>>
>>>
>>>
>>> "H8ids" wrote in message
>>> news:uesZLZEwEHA.3416@TK2MSFTNGP09.phx.gbl...
>>>> Followed FrontPage wizard to create online submission form. Pages
>>>> were generated automatically. Page coding appears to be correct. DB
>>>> was also generated by FrontPage.
>>>>
>>>> The server is utilizing ODBC for the Access DB
>>>>
>>>> Although I can view the pages remotely and I receive a confirmation
>>>> that information has been submitted, the database remains empty.
>>>>
>>>> Any idea about why the "save to database" process is failing?
>>>>
>>>> Dave
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Re: ASP page not saving to DB

> Any idea about why the "save to database" process is failing?

Not sure, do you have a better definition of "failing"?

Re: ASP page not saving to DB

Aaron,

I haven't received any errors online or on the server.
But when I look for the content within the database, while using Access,
it's obvious nothing ever stored in the database.

Dave

"Aaron [SQL Server MVP]" wrote in message
news:ulVG7sGwEHA.384@tk2msftngp13.phx.gbl...
>> Any idea about why the "save to database" process is failing?
>
> Not sure, do you have a better definition of "failing"?
>
>

Re: ASP page not saving to DB

So take "on error resume next" out of your ASP page, and make sure you have
disabled friendly HTTP errors in IE, and then try to save the results again.
Let us know if that turns up anything useful.

Also, make sure you haven't commented out the insert statement, and that you
are looking at the correct table/database, etc.

--
http://www.aspfaq.com/
(Reverse address to reply.)




"H8ids" wrote in message
news:#SsjUkSwEHA.612@TK2MSFTNGP15.phx.gbl...
> Aaron,
>
> I haven't received any errors online or on the server.
> But when I look for the content within the database, while using
Access,
> it's obvious nothing ever stored in the database.
>
> Dave
>
> "Aaron [SQL Server MVP]" wrote in message
> news:ulVG7sGwEHA.384@tk2msftngp13.phx.gbl...
> >> Any idea about why the "save to database" process is failing?
> >
> > Not sure, do you have a better definition of "failing"?
> >
> >
>
>

Re: ASP page not saving to DB

Bob,

I have gone through all of the Access column titles and compared them to
the reserved words for ODBC, Jet and Access. I have a new question.

One of the columns in the database is "GeneralDistributionRequirement" and
one of the reserved words is "General". Could this be the hiccup?

Dave

"Bob Barrows [MVP]" wrote in message
news:OEihCmFwEHA.2540@TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/show.asp?id=2080
>
> H8ids wrote:
>> What does DRW mean.
>> I understand what you mean by reserved name; is there an available
>> list of reserve names? (Using Win 2000 Server, Access 2000 and ASP)
>>
>> Thanks Dave
>>
>>
>>
>> "dave" wrote in message
>> news:%23jytlhEwEHA.2944@TK2MSFTNGP12.phx.gbl...
>>> One common cause of that, is you may have inadvertently used a
>>> reserved name
>>> in your column naming.
>>> As the DRW uses "ON ERROR RESUME NEXT" it may not flag up your error
>>> and the
>>> insert fails.
>>>
>>>
>>>
>>> "H8ids" wrote in message
>>> news:uesZLZEwEHA.3416@TK2MSFTNGP09.phx.gbl...
>>>> Followed FrontPage wizard to create online submission form. Pages
>>>> were generated automatically. Page coding appears to be correct. DB
>>>> was also generated by FrontPage.
>>>>
>>>> The server is utilizing ODBC for the Access DB
>>>>
>>>> Although I can view the pages remotely and I receive a confirmation
>>>> that information has been submitted, the database remains empty.
>>>>
>>>> Any idea about why the "save to database" process is failing?
>>>>
>>>> Dave
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Re: ASP page not saving to DB

> One of the columns in the database is "GeneralDistributionRequirement" and
> one of the reserved words is "General". Could this be the hiccup?

No.

Re: ASP page not saving to DB

This is a multi-part message in MIME format.

------=_NextPart_000_001D_01C4C1A5.78309170
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Aaron,

> "Aaron [SQL Server MVP]" wrote in message =
news:OMQAD2SwEHA.1976@TK2MSFTNGP09.phx.gbl...
> So take "on error resume next" out of your ASP page, and make sure you =
have
> disabled friendly HTTP errors in IE, and then try to save the results =
again.
> Let us know if that turns up anything useful.


I did delete "on error resume next" from each ASP page.
"Friendly HTTP errors in IE" has also been disabled.


> Also, make sure you haven't commented out the insert statement, and =
that you
> are looking at the correct table/database, etc.


The only coding that is commented out in the "submission_form.asp" =
file, refers to the webbot. Which I don't believe is the problem.=20
The has not been commented out. =

However, I have run across a line of code which I don't fully =
understand. Particularly the word "this", below is the line of code.

Re: ASP page not saving to DB

This is a multi-part message in MIME format.

------=_NextPart_000_0031_01C4C1A6.A74782B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I also meant to state that a file titled "Global.asa" is the only =
generated file with reference to the database.

Dave
"H8ids" wrote in message =
news:%2394nEfdwEHA.2804@TK2MSFTNGP14.phx.gbl...


Aaron,

> "Aaron [SQL Server MVP]" wrote in message =
news:OMQAD2SwEHA.1976@TK2MSFTNGP09.phx.gbl...
> So take "on error resume next" out of your ASP page, and make sure =
you have
> disabled friendly HTTP errors in IE, and then try to save the =
results again.
> Let us know if that turns up anything useful.


I did delete "on error resume next" from each ASP page.
"Friendly HTTP errors in IE" has also been disabled.


> Also, make sure you haven't commented out the insert statement, and =
that you
> are looking at the correct table/database, etc.


The only coding that is commented out in the "submission_form.asp" =
file, refers to the webbot. Which I don't believe is the problem.=20
The has not been commented =
out.=20
However, I have run across a line of code which I don't fully =
understand. Particularly the word "this", below is the line of code.

onsubmit=3D"return FrontPage_Form1_Validator(this)" =
language=3D"JavaScript" name=3D"FrontPage_Form1"> =20

Since FrontPage generated the code and database, I don't know what =
"this" means. Also, there are no references to the database or its =
location in the
"submission_form.asp" page.

The pages and the database are not located in the wwwroot folder; =
but I don't have any trouble accessing the pages remotely. Does the =
database need to be in the
wwwroot folder?


Dave





> http://www.aspfaq.com/
> (Reverse address to reply.)
>=20
>=20
>=20
>=20
> "H8ids" wrote in message
> news:#SsjUkSwEHA.612@TK2MSFTNGP15.phx.gbl...
>> Aaron,
>>
>> I haven't received any errors online or on the server.
>> But when I look for the content within the database, while =
using
> Access,
>> it's obvious nothing ever stored in the database.
>>
>> Dave
>>
>> "Aaron [SQL Server MVP]" wrote in message
>> news:ulVG7sGwEHA.384@tk2msftngp13.phx.gbl...
>> >> Any idea about why the "save to database" process is failing?
>> >
>> > Not sure, do you have a better definition of "failing"?
>> >
>> >
>>
>>
>=20
>
------=_NextPart_000_0031_01C4C1A6.A74782B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">