As a cyber requirement there is a mandate to have all communication to database needs to be encrypted.
These are the setting on the Oracle DB Server
Oracle Database Settings:
SQLNET.ENCRYPTION_SERVER = REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128,DES,RC4_256,RC4_128,DES40)
SQLNET.ENCRYPTION_CLIENT = REQUESTED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128,DES,RC4_256,RC4_128,DES40)
The ODBC connection is configured based KB Document ID : KB000016934
"How to enable encryption for ODBC connections to Oracle databases?"EncryptionLevel=3
EncryptionTypes=AES256
DataIntegrityLevel=3
DataIntegrityTypes=SHA1
However, the error SQLCHAR * 0xd9f08120 [104] "[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied" is receved when the connected is attempted.
Rolling back the changes allowed the connection function as expected.