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.

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.

 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. 

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.

Please mark as answer if this has been resolved.