Re: HELP: ODBC & SQL NET

From: Joneveland <joneveland_at_aol.com>
Date: 7 Feb 1999 16:02:22 GMT
Message-ID: <19990207110222.24298.00000919@ng32.aol.com>

>Do I put the name of the Unix Oracle server in server? Do I put the Oracle
>alias
>I created in SQL*NET? Or do I put 'tns:my_alias'? I tried all there, but
>connecting
>give the the error:
>
> TNS:..cannot resolve hostname...

In the file
/orawin/network/admin/tnsnames.ora

there is a listing of the SQLNET connection you made with Easy Net manager.

IT looks like:

SID.WORLD =
(HOST=Yada

      (SID= DADA
     .....

Anyway, you want to type in the alias in the first line, namely "SID.WORLD". Received on Sun Feb 07 1999 - 10:02:22 CST