Re: ORA-12203

Check how many tnsnames.ora file you have on your comp. You might have 2 versions one from Oracle 7 one from Oracle 8, some software tends to try to use the latest.

c:\orawin95\network\admin\tnsnames.ora
c:\orawin95\net80\admin\tnsnames.ora

On Thu, 18 Nov 1999 06:54:07 -0800, Helen <helen.maheuNOheSPAM_at_microcell.ca.invalid> wrote:

>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

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email