OraFAQ Forum: Networking and Gateways » TNS:could not resolve service name

Home » RDBMS Server » Networking and Gateways » TNS:could not resolve service name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS:could not resolve service name [message #66764]

Mon, 23 December 2002 21:17

chandana
Messages: 12
Registered: December 2002

Junior Member

hi all
when i try to connect to Oracle database through VB application i got above error message (TNS:could not resolve service name). but i can connect to database through SQL Plus with same service name. i installed all the component (NT service pack, MDAC 2.5 etc). but it didn't work. so what can i do to fix this problem. pls help me.
Regards
Chandana

Report message to a moderator

Re: TNS:could not resolve service name [message #66765 is a reply to message #66764]

Thu, 26 December 2002 07:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

is there any IIS involved?

Report message to a moderator

Re: TNS:could not resolve service name [message #66771 is a reply to message #66764]

Sat, 04 January 2003 23:47

K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore

Senior Member

sir,

do the following in the client machine.
go to start->>run >> type REGEDIT

then it will open registry.
in that hkey_local_machine--software--oracle--

create a string value
name of the string LOCAL
string value your host string name

then press f5 and close it.

here after you need not put the host string in your application as well as sql plus.

then run the program.

another solution

use filedsn for this case to solve the problem.

k.sreenivasan

Report message to a moderator

Re: TNS:could not resolve service name [message #66837 is a reply to message #66764]

Wed, 29 January 2003 16:09

Bev
Messages: 1
Registered: January 2003

Junior Member

Hi
I have tried the regedit method however, I still get the same result. I have installed forms 6i release 2 and trying to connect to a local database. Anymore ideas that I can try ?

Thanks

Report message to a moderator

Previous Topic:	TNSListner Problem
Next Topic:	virtual circuits

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 04:11:33 CDT 2025