ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
572474Jan 19 2008 — edited Jun 23 2010Hello,
I hit problem this time.
Database server: Oracle 11g Release 1
Tools: Visual Studio 2008 Team System 2008
ODT.NET version 2.111.6.20
When I am trying to connect to Database using SCOTT from either the Server Explorer or Code I get the error:
"ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"
I can connect to the Database using SCOTT from Oracle SQL Devloper or JDeveloper without any problem.
Please help,
Ming Man