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 - 08:39:08 CST
