connecting to oracle

[surya1998]

When I am trying to connect to oracle working in asp.net I am getting the error "ORA-12154: TNS:could not resolve service name", I have defined the service name in the TNSNAMES.ORA and able to log to oracle through SQL Plus.

what could be the possible error for this

thanks in advanc
Varadara

[Miha Markic]

Hi,

Make sure that aspnet local windows account has access to the oracle
folders.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"surya1998" <an*******@discussions.microsoft.com> wrote in message
news:80**********************************@microsof t.com...

When I am trying to connect to oracle working in asp.net I am getting the error "ORA-12154: TNS:could not resolve service name", I have defined the
service name in the TNSNAMES.ORA and able to log to oracle through SQL Plus.
what could be the possible error for this?

thanks in advance
Varadaraj

[Paul Clement]

On Fri, 16 Jan 2004 02:01:08 -0800, surya1998 <an*******@discussions.microsoft.com> wrote:

¤ When I am trying to connect to oracle working in asp.net I am getting the error "ORA-12154: TNS:could not resolve service name", I have defined the service name in the TNSNAMES.ORA and able to log to oracle through SQL Plus.
¤
¤ what could be the possible error for this?

See if the following helps:

HOWTO: Troubleshoot an ASP-to-Oracle Connectivity Problem
http://support.microsoft.com/default...;EN-US;Q255084

Make certain to apply item #10 (in the article) to the ASPNET account for ASP.NET applications.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)