Re: ORA-12203

From: k.vinayak <k_vinayak_at_my-deja.com>
Date: Fri, 19 Nov 1999 13:45:02 GMT
Message-ID: <813k8t$kng$1@nnrp1.deja.com>

Have U configured the DSN and tnsnames.ora properly ? Also check out can you tnsping your ora db by using tnsping80 <tns_name>..
tnsnames.ora is in $ORACLE_HOME\net80\admin dir tnsping80 is in $ORACLE_HOME\bin

HTH,
Vinayak

In article <CpXY3.6045$Ox4.63849_at_typhoon.chello.nl>, "Roland Daane" <r.daane_at_chello.nl> wrote:
> try the MSDAC.EXEon SP 4
>
> Roland Daane
>
> Helen <helen.maheuNOheSPAM_at_microcell.ca.invalid> wrote in message
> news:04ee72e0.76d113f5_at_usw-ex0109-069.remarq.com...
> > I really need help on this one. I try to establish a
> > connection through a IIS server ( web server )with a ODBC
> > connection to a Oracle database. I always receive this
> > message : ORA-12203: TNS : unable to connect to destination.
> >
> > I'm sure than I'm not the only one working on the Intranet
> > and doing connection to a Oracle database.
> >
> > I'm able to establish a connection to a Oracle database
> > localy, but when my connection go through the IIS server,
> > I'm always have the same error message.
> >
> > Oracle version : 8.0.4.
> > SQL Net version : V2
> > ODBC driver : 8.00.0400
> >
> > Thanks
> >
> >
> >
> >
> >
> >
> > * Sent from AltaVista http://www.altavista.com Where you can also
find
> related Web Pages, Images, Audios, Videos, News, and Shopping. Smart
is
> Beautiful
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 07:45:02 CST