Re: No form records are inserted into database

From: xfile (cou-cou_at_remove.msn.com)
Date: 05/23/04

  • Next message: xfile: "Re: No form records are inserted into database" 
    Date: Sun, 23 May 2004 12:57:43 +0800

    Hi:

    My problem is solved but since I am not a real technical profession, so you
    might not trust my solutions at all.

    I redeveloped the ASP page without the template from FP 2003.

    I then create the database and insert the fields corresponded to those field
    names of the form.

    Finally, using form properties, I clicked using database and using options
    to set up the database connection.

    One thing though, I also clicked "update connection" and went to mapped
    fields to ensure form fields are mapped correctly to those table fields in
    the database.

    Finally, I did not put the database in the "fpdb" folder and in "_private"
    folder.

    I also adjusted permission of the subweb by selecting not to inherit from
    the parent folder.

    I also give permission on IIS to have write/read permission for scrip from
    the very top of the default folder and ensure the sub folder also contains
    the same permission.

    Now it works. But honestly speaking, I don't know exactly which one(s) are
    the real cause.

    But if your hosting service provides DNS, it might be much easier as I later
    found out. Although DNS may not as "efficient" as many experts claimed
    which I don't really care at this point for my database is small for a small
    company.

    With the DNS, I first FTP database to the instructed folder (may vary by
    ISP) and to setup a system DNS.

    I then reset form properties using a new database connection (with the
    option of web server or something like server's DNS).

    After that, the form will find the database automatically and I don't even
    know how the hosting company setup the permission - which I also care less
    at this time.

    Hope that help.

    Again, I am not a technical expert and just covering the job for a while. So
    I cannot make a very organized step-by-step instructions for your use.

    Good luck.

    <anonymous@discussions.microsoft.com> ???
    news:1099c01c4401c$718351b0$a401280a@phx.gbl ???...
    > I am having the same problem.Did you ever figure out what
    > was happening?
    >
    > thanks
    >
    >
    > >-----Original Message-----
    > >Funny you should ask that. I have had many different
    > DB's on my web.
    > >However, recently, if I make a new DB, it does the same
    > thing. I get the
    > >confirmation page that I made, but the results won't
    > show up in the table i
    > >created.
    > >The confirmation page you are refering to, is a generic
    > one created by FP if
    > >you don't specify one. It just shows the info that was
    > just submitted.
    > >Anyway, if someone has a solution to this, I also would
    > appreciate it.
    > >Bam
    > >
    > >
    > >"xfile" <cou-cou@remove.msn.com> wrote in message
    > >news:O5wU00tNEHA.3812@TK2MSFTNGP12.phx.gbl...
    > >> Hi:
    > >>
    > >> I use FP 2003 to come up a form for registration
    > purpose.
    > >>
    > >> I first inserted the "Form" and the all text boxes for
    > information needed,
    > >> and used Form Properties to create a database and
    > connection. Checked the
    > >> table and all fields are there.
    > >>
    > >> Finally, I saved the file as ASP as FP 2003
    > instructed, published it to a
    > >> server with 2002 server extension.
    > >>
    > >> When I clicked "submit" there is also a "confirmation"
    > page showed up
    > >> although I don't know where does it come from.
    > >>
    > >> Here is the problem. When I opened up the table
    > (called Result) of the
    > >> database created by FP 2003, nothing in the fields.
    > >>
    > >> So where seems to be the problem? Server
    > configuration, scripts, and...??
    > >>
    > >> Thanks!!!
    > >>
    > >>
    > >
    > >
    > >.
    > >

  • Next message: xfile: "Re: No form records are inserted into database"

    Relevant Pages

    • Re: Linked Server to Access DB Security
      ... Setting read/write on the folder and read/deny write on the database files ... user have READ/WRITE permission on the upper folder; ...
      (microsoft.public.sqlserver.server)
    • Re: Operation must use an updateable query.
      ... Folder remains read only. ... > You need to have write permission for the database file/folder. ... >> Operation must use an updateable query. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Cannot write text to the file located in IIS wwwroot director
      ... Right-click the Pets folder, ... Select the ASP.NET account, and add Write permission. ... >> Editing an Access Database with ADO.Net ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Database problems
      ... Ther permission setting that I gave you is correct. ... The folder containing the database. ... "Steve Grosz" wrote in message ...
      (microsoft.public.frontpage.client)
    • Re: Moving backend to secure folder
      ... read/write/create/delete permissions on the folder. ... some of the users will be blocked from opening the database. ... The users need READ/CHANGE permission. ... "Thou hast proof my son David hast lifted thy plonk, ...
      (comp.databases.ms-access)