In the past I've tended to go with the old client until required for some reason to upgrade it. Reasons for upgrade I've encountered. 1. New db version doesn't support connection from old clients (10g from 8i clients, 8/9 from Oracle 7 clients) 2. New app requires newer drivers (eg 10g ODP.Net). In nearly all cases I've found upgrading clients an extremely problematic exercise. In addition if you are on Windows clients then make sure that the environment (the PATH and CLASSPATH) is set correctly. Multiple OH can occasionally cause conflicts on this platform (though to be fair I've only recently seen this running 2 db versions and 3 app server installs on the same laptop :) ) Niall On 5/8/07, Bryan Wells <bunjibry@xxxxxxxxx> wrote:
My mentors: we are in the midst of migrating from 9i to 10g. we are a small shop, and unfortunatly are bound to the old hardware for the applications hitting the new database. My question is, for our regression testing scenarios. we want to be able to set up multiple client homes on the applications/web etc...? the idea is to utilize 9i for existing requirements, then use the 10g client to test against the new 10g database environment. is this common practice? Thanks B
-- Niall Litchfield Oracle DBA http://www.orawin.info