No form records are inserted into database

[xfile]

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!!!

 

[+FarmerPickles]

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

 

[+FarmerPickles]

Also, if I open the DB itself, the entries are not there. It is like they
were posted into cyberspace or something

 

[xfile]

Yes, exactly.

When I opened the DB, nothing is there.

The most strangest thing is no error message - just gone with the click!!!

Please :-(

 

[Guest]

I am having the same problem.Did you ever figure out what
was happening?

thanks

 

[xfile]

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.

 

[xfile]

One final note:

I just did a small test on the real production site.

If I changed the location of database in the form from Web server's DNS to a
FP folder (_xxx) on the root, it will not insert any records. Why? I don't
know. I guess it has something to do with the hosting company's setup.
They have set a special database folder for MS Access at one folder above
the www-root and need to create a DNS name. But I don't know what it cannot
have write on the _private folder.

So you may need to use DNS only if you are in the same situation.

So far, I am stuck in a dilemma.

My logon database is in the folder and registration database is based on DNS
which means I have two copies of database for the same purpose and should be
in the same location.

I am stuck by the include file (.inc) of the following codes:
-----------------------------------------------------------------------
Const MDB_URL = "/_foldername/database_name.mdb"
------------------------------------------------------------------------
and
---------------------------------------------------------------------------
' Create a database connection object.
Set objCN = Server.CreateObject("ADODB.Connection")
' Open the database connection object.
objCN.Open "driver={Microsoft Access Driver (*.mdb)}; dbq=" &
Server.MapPath(MDB_URL) & "; uid=admin; pwd
----------------------------------------------------------------------------
---

Since the physical location of the database is one level above the wwwroot
and using DNS, I don't know how to modify the two sections by using DNS
instead of physical location. I tried to research on using MDB_URL but very
little articles talking about it. I tied many ways but none of them worked.

So if anyone happened to know how to modify the above by using DNS, please
tell me.

Many thanks!!!