From: eddy.pagotto@...
Date: 2008-02-21T17:20:06+09:00
Subject: Re: Confused about OCI8

In the meanshile I added this to the TNSNAMES.ORA
on a machine with SQLPlus:

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.22)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TEST)
    )
  )

Using "TEST" as connection string, SQLPlus works.
But, using OCI8, how can I use the TNSNAMES.ORA?
Thanks in advance for any help to solve this doubt,

Eddy

On Feb 21, 8:58 am, eddy.pago...@gmail.com wrote:
> No, I cannot connect using the string //10.0.0.22/TEST.
> Maybe I'm understanding: OCI8 uses the SQLPlus approach for
> connections to the DB,
> which is different from JDBC. Am I right or not?
> So, could it be a DB configuration problem? If I'm able to connect
> with SQLPlus
> I'm able to connect with OCI8?
> Best regards,
>
> Eddy
>
> On Feb 21, 4:06 am, Jesse Hu <yiz...@gmail.com> wrote:
>
> > [Note:  parts of this message were removed to make it a legal post.]
>
> > *TNS-12154 TNS:could not resolve service name.*
>
> > Can you connect to the Oracle 8 db using sqlplus with this connection string
> > '//10.0.0.22/TEST"?  The service_name of the db is "TEST"?
>
> > 2008/2/21, eddy.pago...@gmail.com <eddy.pago...@gmail.com>:
>
> > --
> > Best regards,
> > Jesse