On 2011-12-05 07:08:01 -0500, John Scoles wrote: > > From: b...@wards.net > > Date: Sun, 4 Dec 2011 19:15:20 -0800 > > Subject: Re: Maintaining simultaneous support for two Oracle versions in DBI > > To: smi...@latfor.state.ny.us > > CC: dbi-users@perl.org > > > > Aren't the Oracle driver libraries backward compatible? If you link DBD to > > the Oracle 11 drivers, won't it still be able to connect to an Oracle 8 > > server? > > > > No they usually only go back one version. So 9 can connect to 8~10, 10 > to 9~11 ect at least that has been the trend with the last few clients > at least with OCI.
We access an Oracle 8.1 database with 10.2 clients and a 10.2 database
with an 8.1 client, so that works at least for simple stuff (IIRC you
have to be careful about charsets and there are some problems with LOBs,
so YMMV).
Accessing an 8.1 database with an 11g client definitely doesn't work.
I'm not sure whether an 11g client can access a 9i database.
For a transition from a 9i to an 11g database I would first try to use
an 11g client and fall back to a 10g client if that doesn't work.
hp
--
_ | Peter J. Holzer | Auf jedem Computer sollte der Satz Ludwigs II
|_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich
| | | h...@wsr.ac.at | bleiben, mir und andern."
__/ | http://www.hjp.at/ | -- Wolfram Heinrich in desd
signature.asc
Description: Digital signature
