I’ve been testing unixODBC with MySQL and PostgresSQL and recently tried using it with Oracle 11g. After getting everything setup I kept getting the following error
28000:1:1017:[unixODBC][Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied
I finally discovered that this is because Oracle uses “UserID” instead of “User” in the ODBC configuration of the DSN.