[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Microsoft .Net Provider for Oracle fails for asp.net

Ewen McDonald

7/24/2002 5:45:00 PM

When I use the .Net Provider for Oracle on a .Net Windows
form all is well. However, when I do the same on a Webform
the Oraclecon.Open() statement causes the following error:

System.Data.OracleClient.OracleException: ORA-12154:
TNS:could not resolve service name

Any ideas anyone??????

Thanks, Ewen.
3 Answers

Dave Kekish

7/29/2002 4:58:00 PM

0

the error means that it can't find your oracle database. Your first place
to look is in the Oracle home directory for your oracle client install.
Your DBA will probably know what the error is assuming you have one. If
not, i'll try to help but its not my strong suit.

"Ewen McDonald" <ewen.mcdonald@inveresk.com> wrote in message
news:081701c23329$2edce760$19ef2ecf@tkmsftngxa01...
> When I use the .Net Provider for Oracle on a .Net Windows
> form all is well. However, when I do the same on a Webform
> the Oraclecon.Open() statement causes the following error:
>
> System.Data.OracleClient.OracleException: ORA-12154:
> TNS:could not resolve service name
>
> Any ideas anyone??????
>
> Thanks, Ewen.

Ewen McDonald

8/1/2002 2:59:00 PM

0

I hear what you're saying, but the problem only exists on
web forms - I have no problem connecting to Oracle from
Windows Forms.

I think the problem has something to do with IIS setup on
my development pc....

Ewen.
>-----Original Message-----
>the error means that it can't find your oracle database.
Your first place
>to look is in the Oracle home directory for your oracle
client install.
>Your DBA will probably know what the error is assuming
you have one. If
>not, i'll try to help but its not my strong suit.
>
>"Ewen McDonald" <ewen.mcdonald@inveresk.com> wrote in
message
>news:081701c23329$2edce760$19ef2ecf@tkmsftngxa01...
>> When I use the .Net Provider for Oracle on a .Net
Windows
>> form all is well. However, when I do the same on a
Webform
>> the Oraclecon.Open() statement causes the following
error:
>>
>> System.Data.OracleClient.OracleException: ORA-12154:
>> TNS:could not resolve service name
>>
>> Any ideas anyone??????
>>
>> Thanks, Ewen.
>
>
>.
>

(Peter Chong)

8/8/2002 11:02:00 PM

0

Hi, Ewen
Somewhat IIS could not see a map drive or UNC for Oracle Client
check Microsoft knowledge Base Q255084

"Ewen McDonald" <ewen.mcdonald@inveresk.com> wrote in message news:<059901c2395b$55deb0e0$9ee62ecf@tkmsftngxa05>...
> I hear what you're saying, but the problem only exists on
> web forms - I have no problem connecting to Oracle from
> Windows Forms.
>
> I think the problem has something to do with IIS setup on
> my development pc....
>
> Ewen.
> >-----Original Message-----
> >the error means that it can't find your oracle database.
> Your first place
> >to look is in the Oracle home directory for your oracle
> client install.
> >Your DBA will probably know what the error is assuming
> you have one. If
> >not, i'll try to help but its not my strong suit.
> >
> >"Ewen McDonald" <ewen.mcdonald@inveresk.com> wrote in
> message
> >news:081701c23329$2edce760$19ef2ecf@tkmsftngxa01...
> >> When I use the .Net Provider for Oracle on a .Net
> Windows
> >> form all is well. However, when I do the same on a
> Webform
> >> the Oraclecon.Open() statement causes the following
> error:
> >>
> >> System.Data.OracleClient.OracleException: ORA-12154:
> >> TNS:could not resolve service name
> >>
> >> Any ideas anyone??????
> >>
> >> Thanks, Ewen.
> >
> >
> >.
> >