Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC problem
In article <8v69r6$3tr$1_at_news6.jaring.my>, gun <kimpin_at_pl.jaring.my>
writes
>Thanx Andy for replying my question..Can you please check for me the
>following entry in tnsnames.ora
>
>Thanks in Advance...
>
>TCPEXAMPLE =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = orcl.gun2000)
> )
> )
>
Gun,
I would try for a simple version first where the tnsnames entry is the same as the service_name and the ODBC name e.g.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
And have an ODBC DSN that is also set to ORCL.
Also, make sure that your tnsnames.ora files are set in *all* the Oracle homes - it sounds like you might have one home for your Oracle 8.0 (which probably has tnsnames.ora in net80/admin) and Oracle 8.1.6 (which should have it's tnsnames.ora in network/admin).
I hope that this helps,
Andy
-- Andy Hardy. PGP ID: 0xA62A4849 ===============================================================Received on Sat Nov 18 2000 - 16:27:59 CST