Oracle OLEDb

From: Chris Skaryd <no_at_one.com>
Date: Thu, 23 Feb 2006 20:56:42 GMT
Message-ID: <ekpLf.143938$5o2.24290_at_fe06.news.easynews.com>

Is it possible to have the Oracle OLEDB or ODAC drivers for 8i and 10g installed on the same machine?

If so, is there a way to select oracle home's between 8i and 10g?

I have an application written in VB6 against an 8.1.7 database. The database is being migrated to 10g on a separate server. My client would like to run in parallel for a few weeks entering and querying the same data from both servers. The application has been recompiled using the 10g OLEDB/ODAC drivers and needs to run on the same machine as the application compiled against the 8i OLEDB drivers.

I feel that I am missing something fairly basic. But the 10g ODAC install corrupts the 8i Client install and the old application is then unable to connect to the 8i database until all Oracle components are uninstalled and removed from the registry.

Is there any way to make these 2 versions play nicely together?

Thanks in advance for any help. Received on Thu Feb 23 2006 - 21:56:42 CET