ORA-01017: odbc invalid username and password error - Oracle connectivity issue

I have created an user stg in Oracle (19c) inside a new pluggable database - DATADB

Now, I can login to the user easily from sqlplus or sqldeveloper with normal password. But not from ODBC. I am getting following error :

ORA-01017: invalid username / password; logon denied

enter image description here

To solve this problem, I have gone through several articles and many of them suggested to change sec_case_sensitive_login to false

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = false;

Session altered.

SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON;

NAME                     TYPE    VALUE 
------------------------ ------- ----- 
sec_case_sensitive_logon boolean FALSE

But I am still getting same error as above in ODBC, and after changing the parameter, now I am unable to login using sqldeveloper or sqlplus. When I again set it to True,

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = True;

I do not get any error now in sqldeveloper or sqlsplus. Overall, I am not able to use ODBC.

Please help!

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum