From: eddy.pagotto@...
Date: 2008-02-21T22:39:59+09:00
Subject: Re: Confused about OCI8

OK,
all work, finally! :o)
I installed the Oracle client 9.2 on my machine, then configured
the TNSNAMES.ORA with the right service name, and both SQL*Plus
and my Ruby test app work.
Thanks a lot for your support Kubo, and thanks to Jesse for the first
important suggestion.
Best regards,

Eddy

On Feb 21, 11:25 am, KUBO Takehiro <k...@jiubao.org> wrote:
> HI,
>
> On Thu, Feb 21, 2008 at 6:59 PM,  <eddy.pago...@gmail.com> wrote:
> > OK,
> >  to summarize:
> >  1. I have to install the full version of Oracle client
>
> Yes.
>
> >  2. I have to add the service name to TNSNAMES.ORA
>
> Yes.
>
> >  3. To test the connection I will use OCI8.new("<user>", "<password>",
> >  "<service_name>")
>
> 3. To test the connection I will use OCI8.new("<user>", "<password>",
> "<tns_name>")
>
> <tns_name> is a name defined in TNSNAMES.ORA.
> Tns name may be differnet name with service name.
>
> >  So, with Oracle 8 and 9, I cannot use the Instant client 10.x because
> >  I can only use the //<server>/<service_name> form only with 10g
> >  database.
>
> 10g client, exactly speaking.
> 10g client can use //<server>/<service_name> to connect to 9i databases.