Hi dears.
What I need: I would like some help and advise to configure an ODBC connection but the ODBC User ID must be an 'OS authenticated user'.
In other words I have an legacy application that can not supply a password and that application does not work properly when a password is stored in the ODBC configuration.
Said that, ODBC configured with OS authenticated user would be a good solution for my issue. Is that possible to get such configuration working?
What I did:
At this point, I have a properly configured user, I can connect to the Oracle DB through sqlplus without password but I can not get the ODBC connection working with same OS authenticated user.
Is it possible to get the ODBC configuration working? What am I doing wrong?
Find below some print screens:
Connecting without password:
sqlnet.ora and tnsnames.ora files:
ODBC configuration:
The Oracle ODBC driver configuration can not use password in any way. Why my user can not connect to the database through ODBC but my user can connect through SQLPLUS? How could I circumvent such limitation?
Any help will be very welcomed.
Kind regards
Renato.