| 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
|
|
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
