I used the DB connect wizard in FP 2003 to create a simple form that is
supposed to allow data entry into a SQL database. The db connection worked
fine and I published the site okay. When I open the page containing the form,
I am presented with the right fields and when I fill the fields and click
"submit" I get the default form confirmation page.

Problem is, when I open the table on my SQL Server, there are no new records.
help?

Did records get added from the test site?

What db connection settings did you specify? (Of course, don't post your db
password).

Are you sure there's conenctivity between your Web server and your SQL Server?

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming


"BillM" wrote:

> I used the DB connect wizard in FP 2003 to create a simple form that is
> supposed to allow data entry into a SQL database. The db connection worked
> fine and I published the site okay. When I open the page containing the form,
> I am presented with the right fields and when I fill the fields and click
> "submit" I get the default form confirmation page.
>
> Problem is, when I open the table on my SQL Server, there are no new records.
> help?