"Update" gets "page cannot be displayed" error sometimes

[Guest_imported]

I have a page which allows users to enter data in a text box and then hit "update" button. This is supposed to update a database table. Sometimes this works and sometimes the user will get a "Page cannot be displayed" error message. Why is this happenning? I am using ASP, javascript and SQL server.

 

[AncientTiger]

Joe, it sounds like there may be some script errors (particularly ADO errors) being generated, and it furthermore sounds like there's multiple errors on the same page that's "not being displayed". Here's a trick you can try:
==============================================
Function handlerr()

if err <> 0 then
response.write(&quot;Error has occured.<br>&quot
response.write(&quot;<br>Error Description: &quot;+err.description)
response.write(&quot;<br>Error Source: &quot;+err.source)
err.clear 'This clears the error and allows the page to continue
'OR you can choose to halt the page by using
'this: response.end()
End If

End Function

on error resume next
'Your connection script here
Call handlerr()

'More of your script here
Call handlerr()

=====================================================

This is a simple debugging method that I use, and it always seems to work well for catching multiple errors on the page.

Hope it helps
AT

 

[Guest_imported]

Thanks AncientTiger, you saved my tail!