OA-12154 TNS could not resolve service name RSS

• • Reply
  

  santhosh.mm

  0 Points

  11 Posts

  OA-12154 TNS could not resolve service name

  Feb 28, 2008 05:39 AM|LINK

  hi friends,

   i am using windows application,

  that application i have connect to oracle databse.

  i have create TNS name in tnsnames.ora file

   PREPROD.BTSINDIA.COM =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = preprod)
      )
    )

   

  then i am creating connection string in app.config file.

   <add key="ConStr_Orc" value="Provider=OraOLEDB.Oracle;Data Source=prod;User Id=id;Password=pass;" />

   

  Then i will run the application,provide the OA-12154 TNS could not resolve service name .Error

   

  but i am connect in sql editor

  username id

  password pass

  hoststring prod

  it's working correct

   

  please please help me.How to slove the problem.

  it's very very urgent.

   

   

  app.config

  • Moved by DMW on Feb 28, 2008 07:42 AM
• • Reply
  

  sudipta

  Contributor

  2274 Points

  483 Posts

  Re: OA-12154 TNS could not resolve service name

  Feb 28, 2008 09:12 AM|LINK

  First try to connect to the Oracle User using SqlPlus. Check to see if this successful.

  -----------------------------------------------------------------------------------------------------------------------------

  Please click Mark As Answer if this helped in solving your problem.

  Please click "Mark As Answer" if this helped in solving your problem.
  
• • Reply
  

  srijaya_rama...

  Contributor

  5738 Points

  1161 Posts

  Re: ORA-12154 TNS could not resolve service name

  Feb 29, 2008 06:27 AM|LINK

   Plz check these links

  http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm

  http://www.orafaq.com/forum/t/24165/0/

  http://www.thescripts.com/forum/thread65844.html

  http://www.dbforums.com/showthread.php?t=1012623

  http://forums.oracle.com/forums/thread.jspa?threadID=619098&tstart=30

  http://www.databasejournal.com/features/oracle/article.php/3092461

  http://forums.asp.net/t/1197847.aspx

  Thank u

  Baba

  Please remember to click "Mark as Answer" on this post if it helped you. 

  Thank u
  
  Baba
  
  Please remember to click "Mark as Answer" on this post if it helped you.
• • Reply
  

  jsblakley

  Member

  89 Points

  19 Posts

  Re: OA-12154 TNS could not resolve service name

  Feb 29, 2008 04:22 PM|LINK

  I got the same message and followed everything to a "T". But it turned out that I was using the wrong value in my data source. This value has to be the name of your database, not the schema you want to connect to. Give that a try.

  Jeff Blakley
• • Reply
  

  sudipta

  Contributor

  2274 Points

  483 Posts

  Re: OA-12154 TNS could not resolve service name

  May 14, 2008 07:24 AM|LINK

  Please mark as answer if this has been resolved.

  Please click "Mark As Answer" if this helped in solving your problem.