Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 oa-12154 tns could not reslove service name

Author  Topic 

desikankannan
Posting Yak Master

152 Posts

Posted - 2008-02-28 : 01:56:03
hi friends,

i am creating windows application.
the backend i am using oracle db.

i am creating TNS name in tnsnames.ora

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

and creating a connecting string in app.config file
<add key="ConStr_Orc" value="Provider=OraOLEDB.Oracle;Data Source=preprod;User Id=ip;Password=pass;" />

after i am run the application

i get this error oa-12154 tns could not reslove service name

please please help.............

Desikankannan

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2008-02-28 : 02:48:22
What part of "SQL Server forums at SQLTeam" made you believe this was an Oracle forum ?

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-28 : 04:37:01
I think many beginnners don't distinguish between SQL Server manufacturers.

"SQL Server is a server that handles databases" ?
SQL is the same all over the world no matter what company?

For clarification, this could be a better way to profile this site to be a Microsoft SQL Server

"Microsoft SQL Server forums at SQLTeam"



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-01 : 23:15:49
>> oa-12154 tns could not reslove service name

Didn't see any service name in your connection string.
Go to Top of Page
   

- Advertisement -