Re: "ORA-12154: TNS:could not resolve service name" with Oracle Data Provider for .NET
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 24 Jan 2004 06:39:08 -0800
Message-ID: <1074955084.864151_at_yasure>
Date: Sat, 24 Jan 2004 06:39:08 -0800
Message-ID: <1074955084.864151_at_yasure>
jharri wrote:
> I have the exact same scenario, except that I am calling Oracle from a
> web service. When i test the connection from my local machine it works
> fine in a .Net windows application. When i test the connection from
> the server using VBScript or VB6 executable, it works fine. But from
> the .Net web service, it keeps giving ORA-12154. I have tried Oracle
> Net Managed Provider from Microsoft, and OleDB, and both return the
> same error. The web service is in a folder with no parenthesis. And
> it doesn't work even compiled. So the experiences listed above do not
> apply in my case. Ideas welcome.
Post the following four files:
- SQLNET.ORA
- TNSNAMES.ORA ... just the part with this specific instance if the TNS has more than one
- The value of the environment variables ORACLE_HOME and ORACLE_SID as viewed from your application (meaning verify their values from .NET)
- The part of your code used to connect (not too verbose)
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sat Jan 24 2004 - 15:39:08 CET