Oracle9i Client - where is it ? ....
in [Oracle Help]
|
Prev: ORA-00904 over DBLINK
Next: Collect function
From: Frederick Smith on 12 Sep 2009 16:10 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
From: Palooka on 12 Sep 2009 17:11 On 12/09/09 21:10, Frederick Smith 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 ? ... > Use the 10g client. Palooka
From: John Hurley on 12 Sep 2009 19:21 On Sep 12, 4:10 pm, "Frederick Smith" <some...(a)microsoft.com> wrote: snip > 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 can get it from oracle but you may have to open a service request to do so. That will require a valid service contract.
From: joel garry on 12 Sep 2009 20:39 On Sep 12, 1:10 pm, "Frederick Smith" <some...(a)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 jg -- @home.com is bogus. http://www.theregister.co.uk/2009/09/12/linux_zombies_push_malware/
From: Palooka on 12 Sep 2009 21:29
On 13/09/09 01:39, joel garry wrote: > On Sep 12, 1:10 pm, "Frederick Smith"<some...(a)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 |