Oracle9i Client - where is it ? ....

Frederick Smith

unread,

Sep 12, 2009, 4:10:44 PM9/12/09

to

Hi there,

I have been scouring the Oracle website, but cannot find any download for
the Oracle9i Client.

I want to use MS Access to make a ODBC connection to an exiting Oracle9i
database, and want to install these drivers on to a Win XP machine.

Any suggestions ? ...

Regards

Frederick

Palooka

unread,

Sep 12, 2009, 5:11:50 PM9/12/09

to

Use the 10g client.

Palooka

John Hurley

unread,

Sep 12, 2009, 7:21:42 PM9/12/09

to

On Sep 12, 4:10 pm, "Frederick Smith" <some...@microsoft.com> wrote:

snip

You can get it from oracle but you may have to open a service request
to do so.

That will require a valid service contract.

joel garry

unread,

Sep 12, 2009, 8:39:42 PM9/12/09

to

You may be able to use these: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

jg
--
@home.com is bogus.
http://www.theregister.co.uk/2009/09/12/linux_zombies_push_malware/

Palooka

unread,

Sep 12, 2009, 9:29:53 PM9/12/09

to

On 13/09/09 01:39, joel garry wrote:
> On Sep 12, 1:10 pm, "Frederick Smith"<some...@microsoft.com> wrote:
>> Hi there,
>>
>> I have been scouring the Oracle website, but cannot find any download for
>> the Oracle9i Client.
>>
>> I want to use MS Access to make a ODBC connection to an exiting Oracle9i
>> database, and want to install these drivers on to a Win XP machine.
>>
>> Any suggestions ? ...
>>
>> Regards
>>
>> Frederick
>
> You may be able to use these: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
>

Joel,

You may well be right. I have never played with Instant Client.

But the rule of thumb is that regular client versions will always be
backward compatible one major version.

So in this case, 10g client should be fine to connect to a 9i server.
OP should install 10g client and 10g ODBC driver.

He should probably then uninstall M$ Access, but that's a different
issue...;-)

Palooka

vsevolod afanassiev

unread,

Sep 14, 2009, 8:30:01 AM9/14/09

to

Hi,

For some versions Oracle never released separate installation CD for
client,
so the only way to install client is to get CDs for installing
database (3 or 4).
However from memory separate client CD was released for Oracle 9.2 on
Windows.

Frank

unread,

Sep 17, 2009, 10:43:39 AM9/17/09

to

Here: http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_CLT.zip

Not really hard to find, but you may expect otherwise.

Ciccio

unread,

Oct 29, 2009, 11:48:12 AM10/29/09

to

Palooka wrote:

>> I have been scouring the Oracle website, but cannot find any download for
>> the Oracle9i Client.

> Use the 10g client.

One question: does 11g client work with 9i2 RDBMS or not? i.e. may from
sqlplus on a machine that has 11g client installed reach a 9i2 db?

Thanks

joel garry

unread,

Nov 4, 2009, 12:17:53 PM11/4/09

to

Metalink Note: 207303.1 has a matrix of which clients work with which
servers. The 11.2 client with 9.2 server is listed as supported, but
only under Extended Support, which means if it doesn't work and you
haven't been supported continuously since 9.2 was under regular
support and you haven't bought Extended Support, tough noogies. The
note also has some other considerations you may need to think about,
like Oracle Apps and desupported platforms.

Whether it actually works, I couldn't say. Whether you could actually
get a fix under Extended Support, I couldn't say either. I would hope
this configuration would be common enough to fix regardless, but I can
understand Oracle not wanting to put a whole lot of resources into it.

jg
--
@home.com is bogus.

Got root? http://www.theregister.co.uk/2009/11/03/linux_kernel_vulnerability/