C
chinkoh
Hi all
This has been posted somewhere else too. i thought i would try posting
it in more places and organize the problem a little better.
My system is running WinXP pro, IIS5.1, FP2003.
I have successfully created and imported a database into the web. I
have also successfully accessed and displayed the records in the
database using a combination of DRW and direct manipulation of the asp
code. The problem is trying to add records to the database.
I have tried directly creating a form and making sure that the form
fields and database columns match. Connections were also verified. I
accessed the form through the browser and added a record. The operation
completed successfully, however, no data was actually recorded. I have
also used the DIW to no avail. Same problem, successful completion but
no data actually written.
I have seen the KB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;219158
However, that did not help.
A step-by-step of one of the methods I have used is:
1. Create a new database (test.db) with one table (Results), two
fields, an autonumber field for the primary key, and another field
which I have called value1. The field value1 was set to text with
default values.
2. Imported the database into frontpage, which was placed into \fpdb.
The necessary connections were verified.
3. Create a new page and named it test.asp.
4. Inserted a form using Insert | Form | Form.
5 Inserted a text box using Insert | Form | Textbox.
6. In the textbox properties, changed the name to value1 and the rest
of the selections set to default.
7. In form properties, selected 'send to database'
8. In form properties, saved fields, ensured that the formfield and
database columns matched, i.e. both are value1.
9. In IIS, I selected the \fpdb directory and checked, script source
access, read, write,directory browsing, log visits, and index this
resource.
10. Open test.asp in a web browser and key in information. Here I have
entered 'one1' into the lone textbox. hit submit and get a confirmation
page.
11. Open test.db and nothing has been added.
I have also tried letting frontpage create a database and connection
too. From what I understand, this will prevent any errors related to
form field and database columns not being exactly the same. This did
not solve the problem, i.e. I still get a confirmation without any data
actually being written into the database.
I next tried sending the form data to a csv file and a text file. Upon
entering the data into the text box and hitting submit, no default
confirmation page was displayed, and neither of the files contained any
results.
Does this mean that I have a configuration problem? I checked the
permissions, and I have gone to the extent of making all folders and
its contents read, write, and executable.
I have further completed an uninstall and a reinstall of IIS.
I am in need of any suggestions and ideas.
Thanks
Chin
This has been posted somewhere else too. i thought i would try posting
it in more places and organize the problem a little better.
My system is running WinXP pro, IIS5.1, FP2003.
I have successfully created and imported a database into the web. I
have also successfully accessed and displayed the records in the
database using a combination of DRW and direct manipulation of the asp
code. The problem is trying to add records to the database.
I have tried directly creating a form and making sure that the form
fields and database columns match. Connections were also verified. I
accessed the form through the browser and added a record. The operation
completed successfully, however, no data was actually recorded. I have
also used the DIW to no avail. Same problem, successful completion but
no data actually written.
I have seen the KB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;219158
However, that did not help.
A step-by-step of one of the methods I have used is:
1. Create a new database (test.db) with one table (Results), two
fields, an autonumber field for the primary key, and another field
which I have called value1. The field value1 was set to text with
default values.
2. Imported the database into frontpage, which was placed into \fpdb.
The necessary connections were verified.
3. Create a new page and named it test.asp.
4. Inserted a form using Insert | Form | Form.
5 Inserted a text box using Insert | Form | Textbox.
6. In the textbox properties, changed the name to value1 and the rest
of the selections set to default.
7. In form properties, selected 'send to database'
8. In form properties, saved fields, ensured that the formfield and
database columns matched, i.e. both are value1.
9. In IIS, I selected the \fpdb directory and checked, script source
access, read, write,directory browsing, log visits, and index this
resource.
10. Open test.asp in a web browser and key in information. Here I have
entered 'one1' into the lone textbox. hit submit and get a confirmation
page.
11. Open test.db and nothing has been added.
I have also tried letting frontpage create a database and connection
too. From what I understand, this will prevent any errors related to
form field and database columns not being exactly the same. This did
not solve the problem, i.e. I still get a confirmation without any data
actually being written into the database.
I next tried sending the form data to a csv file and a text file. Upon
entering the data into the text box and hitting submit, no default
confirmation page was displayed, and neither of the files contained any
results.
Does this mean that I have a configuration problem? I checked the
permissions, and I have gone to the extent of making all folders and
its contents read, write, and executable.
I have further completed an uninstall and a reinstall of IIS.
I am in need of any suggestions and ideas.
Thanks
Chin