Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Error Handling for Invalid Connection Strings

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-08 : 12:01:43
April writes "I have something set up so the user enters an id/pass, then we try to connect to the database using that information. I have been searching for two weeks, but can't find a procedure to capture the error before it's displayed. If the connection doesn't work, that is, if the id/pass don't work to connect to the database, I want to say, "Hey, you messed up!" and redirect them back to the login page. However, I can't seem to catch the error before it prints the

[Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied

error message and quits entirely.

If you can figure it out, let me know. It can't be that hard, but I sure as anything can't seem to figure it out.

Thanks."
   

- Advertisement -