Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC problem

Re: ODBC problem

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Sat, 18 Nov 2000 22:27:59 +0000
Message-ID: <JRwAGfAvJwF6EwZo@ahardy.demon.co.uk>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US