Oracle - works with Framework 1.1, not with 2.0

[Chris Botha]

Hi, I have a web site on a 2003 server. The web site runs under Framework
1.1 and works with oracle, no problem.
On the same server I have another web site that runs under Framework 2.0 and
connects to the same Oracle database, same connection string. In this case I
get the following error:
ORA-12154: TNS:could not resolve service name

Thanks

 

[Aytaç ÖZAY]

Hi,

Did you check your tns.ora file, and be sure that your ASP.NET 2.0 Web site
can access the tns.ora file.

Have a nice work,

Aytaç ÖZAY
Software Engineer

 

[Chris Botha]

Hi Aytaç, thanks for the response. The tns.ora file is fine - Framework 1.1
is happy with it.
Security was what I had in mind as well, and I did give the ASPNET user full
access to the Oracle directory and it's sub-directories, however, it may be
that it should be another user than the ASPNET user? Any idea what user it
should be?

Thanks again.

 

[Jeff Dillon]

You can use IIS Admin (as a test) and reset the Anonymous user as a valid
domain user.

Jeff