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

I am using the username and password to connect to the database...the oracle backend already has a security module built into it, with sufficient permissions to enable or disable access to the appropriate forms, based on who logs in....

I've tried to do what you're suggesting, but once again, the entire site is done in javascript, not vbscript, and I can't seem to get the syntax correct to perform what you're suggesting.

Then you should post a link to this question in the Javascript forum

The main page is in asp, and asp supports BOTH vbscript and javascript natively...I just happen to be using javascript...all the database connection is done in asp as well....I thought that this was the appropriate forum.

So what I have above should work.
On error resume next
'database connection attempt
If err.number=100 then' or whatever error number is returned
'connection failed - display message
else
'connection succeeded - continue loading page
' all your other code goes here
End if

Your syntax, although correct for asp, only works in an asp page that uses vbscript on the server to do its compilation/parsing.  Since the rest of my site (which I can't change) is done in javascript, I need to find a syntactically(is that even a word?!?!) correct equivalent to the vbscript / asp you've provided.  

I know VB well enough to have done what you suggested, but my hands are tied in regards to the scripting language I have to use....

The equivalent, using javascript, would look SOMETHING like the java try / catch block...I've posted the same question in the javascript forum as well, as per your request.

Your syntax, although correct for asp, only works in an asp page that uses vbscript on the server to do its compilation/parsing.  Since the rest of my site (which I can't change) is done in javascript, I need to find a syntactically(is that even a word?!?!) correct equivalent to the vbscript / asp you've provided.  

I know VB well enough to have done what you suggested, but my hands are tied in regards to the scripting language I have to use....

The equivalent, using javascript, would look SOMETHING like the java try / catch block...I've posted the same question in the javascript forum as well, as per your request.

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...

A request has been made in Community Support to close this question:

http://www.experts-exchange.com/Community_Support/Q_20652282.html

If there are no objections a moderator will finalize this question in 72 hours with

- PAQ the Question and refunding points

Please post any comments here

Thank you,

PashaMod
Community Support Moderator @Experts Exchange