DevOps, CI/CD and Automation

ORA-12154: TNS:could not resolve the connect identifier specified

Driver's SQLSetConnectAttr failed;

Hi All,
I am developing a small application using visual c++. In which I making a ODBC connection to a oracle database
I get the above quoted error.

My connection string inside the application looks as follows

CDatabase m_cDataBase;

BOOL bConnectionStatus = m_cDataBase.OpenEx(_T("DSN=") + m_sGroupConfigServer.cStrDSN T(";UID=")+ msGroupConfigServer.cStrUserName T(";PWD=")+ msGroupConfigServer.cStrPassword cStrConnectionString,CDatabase::noOdbcDialog);

After it got resolved inside program the connection string will look like as follows

BOOL bConnectionStatus = m_cDataBase.OpenEx(_T("DSN=pfax_atx;UID=PF;PWD=pftest”),CDatabase::noOdbcDialog);

My tnsnames.ora file entry looks like quoted below

PFAX_ATX.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = titanium)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pfax_atx)
)
)

My sqlnet.ora files looks as quoted

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world

I created the DSN with name pfax_atx, and test connection was successful.
But still get the following error when i connect it from the application

1007;ORA-12154: TNS:could not resolve the connect identifier specified

Driver's SQLSetConnectAttr failed;
Can some kindly render some suggestion?

Thanks and Regards
Radhakrishnan