Access DB Connection problems

[Hassan Al-Rubaie]

Ok, I'm pretty new to this, so please be patient. Here
the story.

I've got a very simple access database used for people to
enroll in training courses on our intranet server
(Win2003, IIS 6). On the asp page I've hidden most of
the fields and all the user has to do is put in their
name and hit submit and everything is supposed to update
to the database. Well, the confirmation page comes up
like everything works, but when I go to the mdb there is
nothing there. I've tried this with both Access 97 & XP
databases and I get the same problem.

I've done the same thing on our old server which was
Win2000 & IIS 5. One thing I found suggested enabling
parent paths and I've done that, but still nothing
happens? I'm not getting any error messages at all, so
I'm hoping that someone has heard of something like this
before.

Any suggestions? Thanks
Hassan Al-Rubaie

[Aaron Bertrand - MVP]

Take out on error resume next, and make sure you've disabled silly settings
in IE like "show friendly HTTP error messages"

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Hassan Al-Rubaie" <anonymous@discussions.microsoft.com> wrote in message
news:a39b01c3ec0a$6b7cb970$a301280a@phx.gbl...

> Ok, I'm pretty new to this, so please be patient. Here
> the story.
>
> I've got a very simple access database used for people to
> enroll in training courses on our intranet server
> (Win2003, IIS 6). On the asp page I've hidden most of
> the fields and all the user has to do is put in their
> name and hit submit and everything is supposed to update
> to the database. Well, the confirmation page comes up
> like everything works, but when I go to the mdb there is
> nothing there. I've tried this with both Access 97 & XP
> databases and I get the same problem.
>
> I've done the same thing on our old server which was
> Win2000 & IIS 5. One thing I found suggested enabling
> parent paths and I've done that, but still nothing
> happens? I'm not getting any error messages at all, so
> I'm hoping that someone has heard of something like this
> before.
>
> Any suggestions? Thanks
> Hassan Al-Rubaie

[Ray at]

"Hassan Al-Rubaie" <anonymous@discussions.microsoft.com> wrote in message
news:a39b01c3ec0a$6b7cb970$a301280a@phx.gbl...

> Any suggestions?

Show us a relevant snippet of your code.

Ray at work

[Hassan Al-Rubaie]

<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp"
S-DataConnection="CEU" S-RecordSource="TRAINING" U-
Database-URL="CEU.mdb" U-Confirmation-
Url="../DB/confirmation.asp" S-Form-Fields="TITLE
enrollee TYPE TIME DATE" S-Form-DBFields="TITLE\ OF\
COURSE ENROLLEE\ NAME TYPE\ OF\ COURSE TIME DATE" --><p>
Supervisors of Employees<br>
Lunch &amp; Learn<br>
February 18, 2004<br>
12:00pm - 1:30pm<br>
<!--webbot bot="Validation" B-Value-
Required="TRUE" --><input type="text" name="enrollee"
size="20"><br>
<br>
<input type="submit" value="Submit" name="B1"></p>
<input type="hidden" name="DATE" value="2/18/04">
<input type="hidden" name="TIME" value="12PM">
<input type="hidden" name="TITLE" value="LUNCH
&amp; LEARN">
<input type="hidden" name="TYPE"
value="SUPERVISORS OF EMPLOYEES">
</form>

I just used the built in Frontpage 2002 components to do
all of this. I do have VisualStudio.Net, but I'm not
comfortable with it, I've only used it for a C++ class I
took a year ago. And friendly HTTP Error messages are
not turned on.

Thanks,
Hassan

>-----Original Message-----
>
>"Hassan Al-Rubaie" <anonymous@discussions.microsoft.com>

wrote in message

>news:a39b01c3ec0a$6b7cb970$a301280a@phx.gbl...
>

>> Any suggestions?

>
>Show us a relevant snippet of your code.
>
>Ray at work
>
>
>.
>

[Ray at]

eegs... I think you'll have a hard time finding support for this in these
groups if you're allowing Frontpage and Frontpage extensions to do things.
I suggest you either hand-code your ASP code yourself or see if posting your
issue in a Frontpage group yields better support.

Ray at work

"Hassan Al-Rubaie" <anonymous@discussions.microsoft.com> wrote in message
news:b0b601c3ec0d$d859f550$a601280a@phx.gbl...

> <form method="POST" action="--WEBBOT-SELF--">
> <!--webbot bot="SaveDatabase" SuggestedExt="asp"
> S-DataConnection="CEU" S-RecordSource="TRAINING" U-
> Database-URL="CEU.mdb" U-Confirmation-
> Url="../DB/confirmation.asp" S-Form-Fields="TITLE
> enrollee TYPE TIME DATE" S-Form-DBFields="TITLE\ OF\
> COURSE ENROLLEE\ NAME TYPE\ OF\ COURSE TIME DATE" --><p>
> Supervisors of Employees<br>
> Lunch &amp; Learn<br>
> February 18, 2004<br>
> 12:00pm - 1:30pm<br>
> <!--webbot bot="Validation" B-Value-
> Required="TRUE" --><input type="text" name="enrollee"
> size="20"><br>
> <br>
> <input type="submit" value="Submit" name="B1"></p>
> <input type="hidden" name="DATE" value="2/18/04">
> <input type="hidden" name="TIME" value="12PM">
> <input type="hidden" name="TITLE" value="LUNCH
> &amp; LEARN">
> <input type="hidden" name="TYPE"
> value="SUPERVISORS OF EMPLOYEES">
> </form>
>
> I just used the built in Frontpage 2002 components to do
> all of this. I do have VisualStudio.Net, but I'm not
> comfortable with it, I've only used it for a C++ class I
> took a year ago. And friendly HTTP Error messages are
> not turned on.
>
> Thanks,
> Hassan
>
>

> >-----Original Message-----
> >
> >"Hassan Al-Rubaie" <anonymous@discussions.microsoft.com>

> wrote in message

> >news:a39b01c3ec0a$6b7cb970$a301280a@phx.gbl...
> >

> >> Any suggestions?

> >
> >Show us a relevant snippet of your code.
> >
> >Ray at work
> >
> >
> >.
> >

[Aaron Bertrand - MVP]

> I just used the built in Frontpage 2002 components to do

> all of this.

Ugh. Strongly recommend spending a half hour at one of these tutorials.
[url]http://www.aspfaq.com/2183[/url]
That should be about all it takes to remove dependency on FrontPage.

The code you posted, by the way, is not the code that does anything to the
database. I assume that's in ../DB/confirmation.asp

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[Hassan Al-Rubaie]

Thanks for your help. I'll try the frontpage group.

>-----Original Message-----
>eegs... I think you'll have a hard time finding support

for this in these

>groups if you're allowing Frontpage and Frontpage

extensions to do things.

>I suggest you either hand-code your ASP code yourself or

see if posting your

>issue in a Frontpage group yields better support.
>
>Ray at work
>
>"Hassan Al-Rubaie" <anonymous@discussions.microsoft.com>

wrote in message

>news:b0b601c3ec0d$d859f550$a601280a@phx.gbl...

>> <form method="POST" action="--WEBBOT-SELF--">
>> <!--webbot bot="SaveDatabase"

SuggestedExt="asp"

>> S-DataConnection="CEU" S-RecordSource="TRAINING" U-
>> Database-URL="CEU.mdb" U-Confirmation-
>> Url="../DB/confirmation.asp" S-Form-Fields="TITLE
>> enrollee TYPE TIME DATE" S-Form-DBFields="TITLE\ OF\
>> COURSE ENROLLEE\ NAME TYPE\ OF\ COURSE TIME DATE" --

><p>

>> Supervisors of Employees<br>
>> Lunch & Learn<br>
>> February 18, 2004<br>
>> 12:00pm - 1:30pm<br>
>> <!--webbot bot="Validation" B-Value-
>> Required="TRUE" --><input type="text" name="enrollee"
>> size="20"><br>
>> <br>
>> <input type="submit" value="Submit"

name="B1"></p>

>> <input type="hidden" name="DATE"

value="2/18/04">

>> <input type="hidden" name="TIME" value="12PM">
>> <input type="hidden" name="TITLE" value="LUNCH
>> & LEARN">
>> <input type="hidden" name="TYPE"
>> value="SUPERVISORS OF EMPLOYEES">
>> </form>
>>
>> I just used the built in Frontpage 2002 components to

do

>> all of this. I do have VisualStudio.Net, but I'm not
>> comfortable with it, I've only used it for a C++ class

I

>> took a year ago. And friendly HTTP Error messages are
>> not turned on.
>>
>> Thanks,
>> Hassan
>>
>>

>> >-----Original Message-----
>> >
>> >"Hassan Al-Rubaie"

<anonymous@discussions.microsoft.com>

>> wrote in message

>> >news:a39b01c3ec0a$6b7cb970$a301280a@phx.gbl...
>> >
>> >> Any suggestions?
>> >
>> >Show us a relevant snippet of your code.
>> >
>> >Ray at work
>> >
>> >
>> >.
>> >

>
>
>.
>

[Hassan Al-Rubaie]

Thanks for your help. I'll try the frontpage group & the
tutorial you suggested.

Hassan

>-----Original Message-----

>> I just used the built in Frontpage 2002 components to

do

>> all of this.

>
>Ugh. Strongly recommend spending a half hour at one of

these tutorials.

>[url]http://www.aspfaq.com/2183[/url]
>That should be about all it takes to remove dependency

on FrontPage.

>
>The code you posted, by the way, is not the code that

does anything to the

>database. I assume that's in ../DB/confirmation.asp
>
>--
>Aaron Bertrand
>SQL Server MVP
>[url]http://www.aspfaq.com/[/url]
>
>
>.
>