connecting to oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
When I am trying to connect to oracle working in asp.net I am getting the
Click to expand...
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.
 
¤ 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.aspx?scid=KB;EN-US;Q255084

Make certain to apply item #10 (in the article) to the ASPNET account for ASP.NET applications.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top