| ORA-12154: TNS:could not resolve service name [message #67646] |
Wed, 08 December 2004 09:06 |
Jane
Messages: 17
Registered: November 2000
|
Junior Member |
|
|
I'm having a problem to connect oracle database using oledb. Here are the specifics:
Windows XP Professional
IIS 5.0 Server
Oracle 9i Client software (local)
Oracle 9i Database Server (remote)
Visual studio.Net 2002
Microsoft.Net FrameWork 1.0
sConnectionString = "Provider=MSDAORA.1;data source=plum5;Server=plumserver;User ID=xxxx;password=xxx"
I got error ORA-12154: TNS:could not resolve service name.
I use same way to create window form application. There is no problem to connect to oracle database. I am not sure where the problem is. It looks like IIS server set up problem. I have set up persimssions on Oracle home folder(local).
Has somebody gotten this to work based on similar / exact conditions? Any idea about this?
Thanks for your help in advance. :)
Jane
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
