Frontpage MSSQL Database Problem

[Rob]

I have a form which I made with FP 2002. I have a MSSQL database which it
is connected to or at least appears to be connected to. My problem is when
I add information to the form and click the submit button, nothing is added
to the database.

Has anyone here used fp to make a form and connected it to a MSSQL database
and have it work properly who may be able to let me know what I am doing
wrong or have not done?

Thanks,

Rob

 

[Mark Fitzpatrick]

If the database is local, something you can try to do is run the Profiler
tool that comes with SQL Server to watch all the traffic going to the
server. You can customize what Profiler watches and identify what SQL (if
any) is getting passed to the db. Of course, if nothing shows up in Profiler
after a few tries then it's probably a goofy connection string. This often
happens when you have the connection string use a "trusted connection" which
passes your windows account information to the server. The problem here is
the account that is passed to SQL Server is the anonymous internet account
(IUSR) account which is automatically rejected by SQL Server since the IUSR
account shouldn't have too much access to the db directly. Adding a sql
server login to the connection string can often help.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage