Unable to connect
SQLState=28000
[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
2 comments:
I would like to know how i can create a user and password to my database because i've forgotten the main one and i ain't got password of none of them and my SYSDBA ask me for a password.
Hello, Thank you for your article share with us. It's very helpful for me. If you want to generate strong password then check my Online Password Generator Tool.
Post a Comment