ORA-01017: invalid username/password; logon denied
Today I faced a not too funny challenge. We had to downgrade the oracle driver (i.e. ODP.NET) from version 11.2 to 10.2 and guess what? I got the “ORA-01017: invalid username/password; logon denied” error. It turned out that ODP.NET 10.2 and prior uses case insensitive passwords and will convert the password to upper case when connecting to the database.
To fix the issue we had to wrap the password with double quotes
Data Source=MyTsn; User ID=MyUserId; Password=”mypassword”