Database connectivity Question

[OD]

I created a Web page using FrontPage Database Wizard so that users can add record into an SQL server. I selected to use ASP.NET. It is working ok, but everytime a user clicked the Submit button without filling in a required field, the database generate error for this user and the next users will not be able to access the database anymore unless I stopped and restart SQL server. Is there a way to prevent this from happening?

Thanks!

OD

 

[Thomas A. Rowe]

If you have form field validation, then the users should not be able to submit the form.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

I created a Web page using FrontPage Database Wizard so that users can add record into an SQL
server. I selected to use ASP.NET. It is working ok, but everytime a user clicked the Submit button
without filling in a required field, the database generate error for this user and the next users
will not be able to access the database anymore unless I stopped and restart SQL server. Is there a
way to prevent this from happening?

Thanks!

OD

 

[OD]

They are not able to submit because there is validation on their they get
the correct error message. However, after that, no one can add data to the
database on the same table until the SQL server service is restarted. Any
Ideas?

 

[Thomas A. Rowe]

If no one can submit after a failed attempt, then you have more then just form field validation
setup on your form.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================