Oracle - works with Framework 1.1, not with 2.0

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

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" <chris_s_bothaAT@hotmail.com> wrote in message
news:eDtibLYXGHA.4484@TK2MSFTNGP02.phx.gbl...
> 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
>

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.

"Aytaç ÖZAY" <aytacozay@hotmail.com> wrote in message
news:%23WB7DMZXGHA.3808@TK2MSFTNGP04.phx.gbl...
> 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" <chris_s_bothaAT@hotmail.com> wrote in message
> news:eDtibLYXGHA.4484@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>
>

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

Jeff

"Chris Botha" <chris_s_bothaAT@hotmail.com> wrote in message
news:u6xK4ZZXGHA.5096@TK2MSFTNGP03.phx.gbl...
> 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.
>
> "Aytaç ÖZAY" <aytacozay@hotmail.com> wrote in message
> news:%23WB7DMZXGHA.3808@TK2MSFTNGP04.phx.gbl...
>> 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" <chris_s_bothaAT@hotmail.com> wrote in message
>> news:eDtibLYXGHA.4484@TK2MSFTNGP02.phx.gbl...
>>> 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
>>>
>>
>>
>
>