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.
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 |
|
|
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" |
|
|
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. |
|
|
|
|
|