Asp Error Handling Database
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about
Asp On Error
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask asp on error goto Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. exception handling in asp.net c# Join them; it only takes a minute: Sign up Is try-catch like error handling possible in ASP Classic? up vote 26 down vote favorite 9 What options are there in ASP Classic for error handling? For example: I'm using http://www.codeguru.com/csharp/.net/net_general/debugginganderrorhandling/article.php/c19557/ASP-and-the-Error-Handler.htm the Mail.SendMail function but when switching on the testing server it doesn't work, which is normal. I want to test if mailing is possible, if not then continue and/or show a message. Any ideas? error-handling asp-classic share|improve this question edited Nov 19 '11 at 2:52 casperOne 57.9k10126202 asked Jan 23 '09 at 11:08 Sander Versluys 22.9k186785 add a comment| 8 Answers 8 active oldest votes up vote 37 down vote accepted There are two approaches, you can code in http://stackoverflow.com/questions/472558/is-try-catch-like-error-handling-possible-in-asp-classic JScript or VBScript which do have the construct or you can fudge it in your code. Using JScript you'd use the following type of construct: In your ASP code you fudge it by using on error resume next at the point you'd have a try and checking err.Number at the point of a catch like: <% Dim i ' Turn on error Handling On Error Resume Next 'Code here that you want to catch errors from ' Error Handler If Err.Number <> 0 Then ' Error Occurred / Trap it On Error Goto 0 ' But don't let other errors hide! ' Code to cope with the error here End If On Error Goto 0 ' Reset error handling. %> share|improve this answer edited Oct 17 '12 at 11:42 Shadow Wizard 49.1k1385130 answered Jan 23 '09 at 11:19 Wolfwyrd 10.2k42861 2 +1. Javascript. If you need it, forget VBscript use javascript. –AnthonyWJones Jan 25 '09 at 23:24 add a comment| up vote 7 down vote A rather nice way to handle this for missing COM classes: Dim o:Set o = Nothing On Error Resume Next Set o = CreateObject("foo.bar") On Error Goto 0 If o Is Nothing Then Response.Write "Oups, foo.bar isn't installed on this server!" Else Response.Write "Foo bar found, yay." End If share|improve this answer answered Sep 9
Tutorials MSDN Communities Hub Official Docs Security Stump the SQL Guru! XML Info Information: Feedback Author an Article Published: Thursday, June 03, 1999 Error Handling in ASP You just finished your ASP application in time, barely making the dealine! As you http://www.4guysfromrolla.com/webtech/060399-1.shtml upload the final version to the webserver, you receive an email from your supervisor indicating that he's ready for your demo. You confidently stride into his office and give him instructions on accesses the application through the http://www.codeproject.com/Questions/404785/Error-handling-in-Classic-ASP Intranet. -continued- Your boss comes to the first page, and is asked to enter his name. You've created a slick, customized feel to the site, recording the user and his or her preferences in a database. Your error handling boss types in his name, "The Pointy Haired Boss," and hits the submit button. Instead of being taken to the next page, he sees the following text pop up on the screen: Microsoft OLE DB Provider for ODBC Drivers error ' 80004005' [Microsoft][ODBC Access 97 ODBC driver Driver] syntax wrong near ' Please note that I just made this error message up, so, please, no emails asking about how one gets this error by asp error handling entering his name! You get one of those looks from your boss, a look that says, "I hope you weren't expecting a positive performance review." There's nothing worse to an end user than to see those dreaded ADO errors. They are misformatted, cryptic, and leave the user wondering what they are suppose to do. Your average end user doesn't know ODBC from OLE. So how can you prevent these nasty error messages? First you must insert at the top of your ASP page:
<% On Error Resume Next %>This will tell ASP to just skip over any errors, instead of halting execution and printing out a nasty error message. You may be tempted to leave it at this, although if you do, and errors occur, your users won't be aware of them. They will think their information was correctly saved, when in actuality it wasn't due to an ADO error. What, then, do we want to do if there is an error? Well, the idea situation would be to let the end user know that an error had occurred and will be worked on, and automatically email technical support with the ADO error messages. So that is what we will do! Page 2 ASP.NET [1.x] [2.0] | ASPMessageboard.com | ASPFAQs.com | Advertise | Feedback | Author an Article
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ Error handling in Classic ASP Rate this: Please Sign up or sign in to vote. See more: ASP What are the ways in which error handling can be done in Classic ASP? Posted 15-Jun-12 17:26pm Bhavana P737 Add a Solution 2 solutions Top Rated Most Recent Rate this: Please Sign up or sign in to vote. Solution 1 Accept Solution Reject Solution Hi Princess, Here are few links that will help you out: Error Handling in ASP [^] ASP and the Error Handler[^] How do I log / track ASP errors on my web site?[^] Hope it helps! Permalink Posted 15-Jun-12 18:49pm Sandeep Mewara505.3K Comments Princess Bhavana 16-Jun-12 1:51am Thank you Sir, the data shared is very useful. Sandeep Mewara 16-Jun-12 4:44am Welcome. Rate this: Please Sign up or sign in to vote. Solution 2 Accept Solution Reject Solution Here is a solution on error resume next set RSDist = objCmd.Execute() ' any error command CheckError 'Function to check Database Errors if session("TransError")="Y" then response.end on error goto 0 function CheckError() session("TransError")="N" if Err.Number <> 0