HI all,
I am having an issue with connecting Oracle DB using tnsnames and ending up with the message "ORA-12154: TNS:could not resolve the connect identifier specified"
I am trying to establish the connection from asp.net using framework 2.x. What I am trying to do is replace the drivers of oracle from 32 bit to 64 bit drivers. I am running my application on Windows 7 64 bit version (Enterprise Edition).
When I suffix the host name to the DB name I am able to connect to the DB but I cannot do that as all applications in the organization is using just the dbname and rest of the information from tnsnames file.
This issue is happening only from ASP.net applications. I am able to connect to the database when I wrote test application using winforms.
Oracle driver version I am using is 2.112.3.0 (Oracle.DataAccess.dll). The server is Oracle 10g. Other applications such as TOAD and Oracle SQL Developer applications use the same tnsnames.ora and able to connect.
Thank you in advance and look forward to hear from the community and any help is greatly appreciated.
Mahidhar