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>


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:

  1. SQLNET.ORA
  2. TNSNAMES.ORA ... just the part with this specific instance if the TNS has more than one
  3. The value of the environment variables ORACLE_HOME and ORACLE_SID as viewed from your application (meaning verify their values from .NET)
  4. 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

Original text of this message