12 Replies Latest reply on Jun 23, 2010 2:48 PM by 781027

    ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

    572474
      Hello,

      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