Unable to connect
[Oracle][ODBC][Ora]ORA-01017: invalid username/password; login denied
The user reported, and the tech verified that on this machine they could login with sqlplus but not ODBC on this PC. Multiple accounts were tried.
Interesting test case illuminated the issue: Created user with ALL UPPERCASE PASSWORD. Using this, could connect through ODBC.
The ancient 9i ODBC connection will not send a case sensitive password.
Made the following change, problem solved, user is happy though we probably could use this as an opportunity to force upgrading ODBC clients:
alter system set sec_case_sensitive_logon=FALSE scope=both