Front Page Form and Database Integration

[Pete]

Hello All,

I am trying to (test) a form using my http://localhost machine. The test
involves a access db and a simple data collection form. I have activated
server 2002 extensions, applied all security updates, and done the followin:

1. Run the database wizard.
2. Recognized the databse and made sure there was a global asa file
3. Saved the form as an .asp
4. Modified security settings for the folder and subfolders to allow
read/write
5. Made sure that the form properties has database selected.

I installed (published) the web built in fp using the publish feature and
made sure it was located on the root server directory
http://localmachine_name/quiz.

After repeated attempts, I cant get the form to write to the database and am
truly frustrated. Anyone have any other thoughts, ideas or suggestions or
should I just give it up?

Thanks,

 

[Thomas A. Rowe]

Open IIS MMC, then the specific web site, then click on Home Directory and set the application root.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

 

[Pete]

I thought that might be the problem. Im not quite sure how to do that . Could
you give me a bit more amplification on how I should do that? I figured the
only thing left was a root issue but I am pretty weak on that subject.

Any help would be great.

Thanks,

Pete

 

[Thomas A. Rowe]

It is at the bottom of the home directory tab, click to create or click to remove/delete then click
to create.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

 

[Pete]

Hi Thomas,

Thanks for the tips. I have found the right menu items but could use some
help to make sure I dont do anything irreversible.

In the properties menu I see the "set home directory" feature. In the
selection window the path is c:\inetpub\wwwroot I have three subwebs with
the one I want to use for testing purposes is called "quiz" Would I set the
home directory to c:\inetpub\wwwroot\quiz ? If so, what changes are there to
accessing the site and what impact would that have on the other sites I have?

Presently I access my localhost via http://computername/quiz Would that
continue to be the same?

Thanks for the assistance!!

Pete

 

[Thomas A. Rowe]

Do not change anything related to "set home directory" !

On the home directory tab, at the bottom you should see a section called "Application", do you see
this?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

 

[Pete]

Yes....I see the selection for application and it is currently set to
"default applicatoin".

 

[Thomas A. Rowe]

Click delete or remove, then click create / configure, etc.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

 

[Pete]

Ok...I found that function and did the delete and create but have no idea
what I need to add to the configure portion. Am I just trying to reset the
root? I did that from top to bottom and the web works fine but the form still
wont write to the database. Most frustrating. Everything seems to be set
including the recognition process, the gsa file, the page has been saved as
..asp, etc.

The application root keeps changing back to "default application". Do I need
to change that to something else such as _access?

THanks,

Pete

 

[Thomas A. Rowe]

No don't change anything under the IIS MMC.

How did you get the database into your current open FP web, and can you verify the connection to it,
via Tools | Site / Web Settings | Database?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

 

[Pete]

Hi Thomas,

Yes, I can verify that it is there and checked so it is the active database.
I used front page and published the web to my localhost/quiz website.

Pete