Search code examples
c#oracle-databasetnsnamestns

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


I know this questions with title like these are common, but I couldnt find solution on these and my question is bit different.

I'm trying to use login authenification via database via VPN. Oracle SQL Developer can connect perfectly using TNS, but c# app cant and I am getting this error (cant check if this is right error number right now, but problem is still same, I will check it tomorrow). I cant share login data from job, so any ideas what can be wrong are welcome.

Edit: I forgot to mention, I have seen just the bit of implementation, but we were trying to try connection via odbc and it didnt work either, just oracle sql developer was able to connect


Solution

  • Problem was in tsnnames.ora, some magic characters appeared somewhere