Deliberate DSN-Less Connection to SQL Server Database, Convert Error Message to Meaningful Text |
Deliberate DSN-Less Connection to SQL Server Database, Convert Error Message to Meaningful Text |
JohnnySteel |
Nov 5 2018, 10:13 PM
Post
#1
|
Newbie Group: Members Posts: 16 Joined: 8-June 16 Member No.: 24,307 |
Sorry, the heading should read "Deliberate DSN-Less Connection Failure to SQL Server Database". I couldn't change this as there does not appear to be means to do so.
I'm getting an (expected) error message with a DSN-Less connection to a SQL database on a SQL Server that says: "Microsoft OLE DB Provider for SQL Server error '80040e4d' Login failed for user '<username>'" Now, i know why the connection failed as it was deliberate on my part to cause this error. I want to trap this error and convert it to text to say the database is not available, such as when it is shut down to do software maintenance on it, etc., rather than display the error message like the one given above. How do i trap this error and convert it into some meaningful text on the web page to say the database is not available? The code i am using is ASP Classic. Thank you. This post has been edited by JohnnySteel: Nov 5 2018, 10:41 PM |
JohnnySteel |
Nov 11 2018, 09:13 PM
Post
#2
|
Newbie Group: Members Posts: 16 Joined: 8-June 16 Member No.: 24,307 |
Thank you. This is the answer I came up with, and it works:
ON ERROR RESUME NEXT conntemp.open myDSN 'This activates the database connection, as given above this code. IF ERR.NUMBER <>0 THEN 'There is far more than just one error code for this failure. Hence, "<> 0 ". DBConnection="0" ELSE DBConnection="1" END IF ERR.CLEAR Then in the web page, retrieve the value for DBConnection and evaluate it. Where DBConnection="0", this indicates a failure to connect. For connection failuire, display the text "Database Unavailable" on the web page, otherwise, continue with producing the asp web page normally. Testing has shown it to work well. Now implementing it into the production system. Does this all make sense? |
Lo-Fi Version | Time is now: 25th April 2024 - 09:25 AM |