?
Solved

Trapping the asp 0113 error

Posted on 2002-04-18
4
Medium Priority
?
377 Views
Last Modified: 2008-02-01
How can I trap the 'ASP 0113 Script timed out' error in asp code, as the Err.Number is comming back as 0 even when the script times out. My code is as follows:

on error resume next
Set RSOrdersTable = OBJdbConnection.Execute(SQLQuery)
errno = Err.Number
errmsg = Err.Description
on error goto 0
if errno<>0 then
  response.redirect("dberror.asp?errmsg=" &   server.urlencode(errmsg) & "&process=" & Server.URLEncode("Retrieving List of Orders"))
else
  .....display orders etc...
end if
0
Comment
Question by:sharon_brindley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 20

Expert Comment

by:jitganguly
ID: 6951027
Take off on error goto 0 and try
0
 
LVL 46

Accepted Solution

by:
fritz_the_blank earned 200 total points
ID: 6951058
You will need to change the connection name for the second part of this to match your connection name, but:

'VBScript errors
If Err.Number > 0 Then
    Response.write("<p><hr>The following VB Errors Occured<p>")
     Response.write("Error Number: " & Err.number & "<br>")
     Response.write("Error Source: " & Err.source & "<br>")
     Response.write("Error Description: " & Err.description & "<br>")
End If

'Connection errors
dim iCounter
if objConnection.Errors.count > 0 then
    Response.write("<p><hr>The following Connection Errors Occured<p>")
    for iCounter = 0 To objConnection.Errors.Count - 1
          Response.write("Error Number: " & objConnection.errors(iCounter).number & "<br>")
          Response.write("Error Description: " & objConnection.errors(iCounter).description & "<br>")
          Response.write("SQL State: " & objConnection.errors(iCounter).SQLState & "<br>")
          Response.write("Native Error: " & objConnection.errors(iCounter).NativeError & "<br>")
    next
end if
0
 

Author Comment

by:sharon_brindley
ID: 6952932
This didn't solve the problem, I found the answer on the Microsoft Knowledge Base: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q182036

But I'll give you the points anyway because you taught me something I didn't know which has come in useful for another problem!
Thanks
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 6953318
Thank you Sharon.

Fritz the Blank
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question