Form results into a database.

[Guest]

Hi,

I am trying to send the results of the form to a database. I have used the
option 'Send to database'. When I submit, I get the confirmation page that I
have specified but when I see the database, I don't see anything in the
database. What am I missing here ?

I am using Frontpage 2003

Thanks,
Roopa

 

[xx75vulcan]

In FP 2003 go to "tools" menu then "site settings" then finally the
"database" tab. In that window, you will see the database connection
for the database you're trying to link to. Click Verify. If it is able
to verify then we can move on. If not, then you have to make sure the
database is still there. (Usually in a folder called "fpdb")

If it's still there, check to make sure you didn't place any
permissions on the database. (ie: passwords).

More importantly, If you designed the database outside of Frontpage,
and created certin limits to fields (ie: a max/min length to a
particular field, or only numeric responses) and then used frontpage to
link to it...if a user does not follow that specific layout of input,
Frontpage will still display a message of confirmation when the submit
button is clicked, but won't actually commit to the database.

let us know what you find with the "verify" database connection.


**Some Mistakes are too fun to only make once**

 

[Guest]

Yes.. 'Verify' does have the database and I checked the fpdb folder and the
database exists in the folder.

I have created the database using the 'create database' option on the form
properties. I am using FP 2003 and running IIS on my local machine. I did
not find server extensions for 2003. I tried to install server extensions for
2002 but it gave some error messages while installing it but when I checked
the installed programs I did find the server extensions installed.

Any ideas of where I am going wrong ?

Roopa

 

[xx75vulcan]

Sorry to take so long to get back to you- One follow up question- How
are you checking to see if there's anything in the database? Are you
looking into the FPDB folder and manually opening the access database
file? Or are you using a results form that displays the contents of the
databse? I ask because if you're relying on another form to display the
contents, that form could be mis-coded.

 

[xx75vulcan]

DEar Roopa,

Are you using a webserver, or hosting this form from a disk-based
server? I just hosted a form on my personal PC at home, and had the
same problem you did, until I selected to share my C:\ . The Folder
that the database is in is: c:\inetput\wwwroo\fpdb\ but you only need
to share the C drive.

Previously to sharing, it was appearing to successfully submit, and the
database connection was verified..

 

[Stefan B Rusynko]

That's a dangerous security risk (sharing entire C: drive)
- you should only ever set the folder w/ the DB in it to be shared (if needed)
And that is not required if you are using a server based web (http://localhost) and have imported the DB in to the root web allowing
FP to set the permissions in the fpdb folder
(you should not be using c:\inetpub\wwwroot\ - that's a disc based location that will corrupt IIS)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| DEar Roopa,
|
| Are you using a webserver, or hosting this form from a disk-based
| server? I just hosted a form on my personal PC at home, and had the
| same problem you did, until I selected to share my C:\ . The Folder
| that the database is in is: c:\inetput\wwwroo\fpdb\ but you only need
| to share the C drive.
|
| Previously to sharing, it was appearing to successfully submit, and the
| database connection was verified..
|