Invalid username / password....how to catch errors??

http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20650074.html

This is the same question posted to the asp pages...there, one of the experts told me it was a javascript problem...my initial thought was that this was purely an asp problem, but he lead me to believe that it was a javascript problem, since I am using asp/javascript, not asp/vbscript.  

Either way I will try to explain things better.

When a user arrives at the site, they enter their user name and password.  These are then written to session variables in asp, and sent to the database to create the connection with the database server.  Based on the roles and privileges that the user has, they will be able to access a minimal set of pages.  What I'm looking to do, is something like a try / catch statement...specifically so that I can try to make the connection to the oracle database, then catch if the error that is occuring is due to an invalid username / password.

Yes, cubrovic is correct.

Either you use error-handling within your asp page or you change the existing error pages within IIS.

1) errorhandling:

On Error Resume Next

...

If(Err.Number<>0) Then
  Err.Clear
  Response.Redirect("errorpage.htm")
End If

2) Change existing error pages in IIS (recommended):
Go to the IIS Management console
Rightclick on the website -> Properties
Go to custom errors
Select 500.100 and change it to the page you want.

Think of it. You get an internal server error and the problem is related to the client? Uhhh, nope.. :-)

If you are using ASP with JScript you'll need to
use a try { } catch () {} block to trap the exception
that the connection object raises.

try
{
   // attempt to connect
}
catch ( e )
{
   // check the properties of the exception object e
}

K

Sooooo...here's the deal.  I am trying to authenticate in Oracle.  There is no single 'user' table which is nicely setup to have a username / password column which I can compare against.  Instead, each of the users of the asp application will login with an asp login page, directly to the oracle database.  The roles and priveleges granted for each oracle user will be used to determine which pages the logged in user has access to.  

The problem I have, is that if they login with an incorrect username or password, it spits back an error page.  I've taken the advice of CJ_S and changed the default error page for a 500.100 error message, but this doesn't work.  The reason this doesn't work, is that the 500.100 error message is an ASP compilation error.  The error arises from an Oracle odbc error.  My best guess, is that you try logon to oracle with the wrong user name password, and it spits back an error, which is interpreted by ASP, and displayed on the page.  If I change the default action of the 500.100 error page, then ANY ASP errors that occur will redirect the user to the new page.  This is not an acceptable solution.  

All I want to do, is find a way to do some sort of 'if then else end if' or 'if () { } else { }' which will allow me to redirect the user to a different page IFF (if and only if) they are trying to login to the oracle page with an incorrect username / password.  

The specific Oracle error is ORA-01017:invalid username / password....is there a way to check for oracle errors within asp???  

I've tried to use asp / vbscript to 'catch' the error using 'On error resume next' as suggested by GaryC123, but that still allowed the error to occur....I am assuming it occurred for much the same reason that changing the default action of the IIS server to redirect all 500.100 errors wont work...

I originally thought this to be a simple thing...something syntactical that I was missing with my attempts...I'm beginning to think that maybe it's more difficult than I originally thought...any other suggestions would be greatly appreciated.  Thanks again all...

colinderekwright:

I have had no success on doing java try / catch blocks within asp / javascript....if you know of the correct syntax for this, please post