Form Data Not added to Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using FrontPage 2003, Windows 2000Server, I created a simple form with 4
fields. I can input the data and click submit and get a confirmation page,
but the data does not get into the access database. We had Frontpage create
the database connection automatically, which was successful.
 
Make sure the web site in IIS MMC under it properties dialog, Home directory has the Application
Root set.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Do you need to set an OBDC connection on the server and point to the
database? I have a virtual directory setup within my main web site, with
this in mind, where do i need to check the application root set?

Thanks,
 
I have clicked on the virtual dir>properties>Home Dir>and the app name is my
database name. Do you need to have the path or just the name there? Also my
database is located in the main web in the folder fpdb with the customer.dbf
database and a results table within the database.
In summary:
-My form is setup
-I receive a confirmation page
-The form is in a Virtual Dir
-The database is located in the folder fpdb named customer (no extensions or
path)
-Scripts and Executables and Low (IIS Process)
-I made sure there was no obdc mdriver specified in the control panel, Do i
need this, i tried it both ways and it did not make a difference.
Anything else it could be or I am missing

-The application name specified in the virutal Dir>Application is customer
 
Yes, you must have a database connection setup on the server. FP extensions do not work with virtual
directories, if you want to store the database outside of the web root, then use a System DSN
database connection.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
That's not using a database connection (see thread below)
You have a send to file (form_results.csv) in a disc based path that probably does not exist
(fpweb:///_private)
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.csv"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->

--




| <html>
|
| <head>
| <meta http-equiv="Content-Language" content="en-us">
| <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| <title>New Page 1</title>
| </head>
|
| <body>
|
| <form method="POST" action="--WEBBOT-SELF--">
| <!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.csv"
| S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
| <p>FIRST NAME</p>
| <p><input type="text" name="FirstName" size="20"></p>
| <p>LAST NAME</p>
| <p><input type="text" name="LastName" size="20"></p>
| <p>STUDENT ID</p>
| <p><input type="text" name="StudentID" size="20"></p>
| <p>COURSE</p>
| <p><input type="text" name="Course" size="20"></p>
| <p>EMAIL</p>
| <p><input type="text" name="Email" size="20"></p>
| <p><input type="submit" value="Submit" name="B1"><input type="reset"
| value="Reset" name="B2"></p>
| </form>
|
| </body>
|
| </html>
|
|
| "John Cello" wrote:
|
| > Can you post a sample of your page code for us to look at?
| >
| > John Cello
| > John Cello Consulting
| > Communications for Business
| > www.johncelloconsulting.com
| >
| >
| > "KMD" wrote:
| >
| > > I am using FrontPage 2003, Windows 2000Server, I created a simple form with 4
| > > fields. I can input the data and click submit and get a confirmation page,
| > > but the data does not get into the access database. We had Frontpage create
| > > the database connection automatically, which was successful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data not going into database 1
Linking Forms 6
Sending an e-mail when a database is updated via a web form 11
Form data not saving to Access database 2
Data doesn't transfer FrontPage form to existing Access database 6
Saving form results to database 3
Confirmation form appears, no info is written to the database ,id field increment 3
Update database from Frontpage Form 2

Back
Top