From: KUBO Takehiro <kubo@...>
Date: 2008-02-21T19:25:33+09:00
Subject: Re: Confused about OCI8

HI,

On Thu, Feb 21, 2008 at 6:59 PM,  <eddy.pagotto@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.