Currently I have an application with a signon screen where the user inputs logon id and password. I then validate this against an Oracle table entry. There is one Oracle ID and password assigned to my app. Now the DBA is creating an Oracle id and password that matches each of my user id and passwords. This works fine as long as the userid and password are correct. However, when either the id or password are wrong I get:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied
I am getting the error on the connection open command. How do trap this error and redisplay my entry screen with the appropriate message?