How to solve "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" error? I am trying to create connection with the database for debugging ASP.Net website. Database is 11g Oracle DB... There is no problem when I connect using SQL Developer, however using Visual Studio I get the error of ORA-12514 (TNS:listener does not currently know of service requested in connect descriptor). 11g ODAC for Visual Studio 2010 has been configured as well.  There are similar questions about this error, I could not find solution for my problem.

Thanks in advance for the help!!!
I do not have any clear explanation for this problem solution. However I used SID instead of service name in connection string and it worked.

Edit: A service name is more flexible than a SID would be. A database can dynamically register with a listener using one or more service names. In fact, more than one database can register with a listener using the same service name.A database on the other hand has a single SID. And a single SID goes to a single database. So I would say it is safe to use SID rather than service name.