Installing Oracle Client for Window 7 to Oracle 9i Database

I’m using 64bit Window 7 for developing applications for Oracle 9i.  These includes development in SQL Developer, MS SQL Server DTS and MS Access 2007.  MS Access 2007 may specially require connection using odbcad32.exe (ODBC 32 bit, located in C:\Windows\SysWOW64 )

High Level Steps:

1. install 64bit Oracle 11gR2 client in Oracle Home 1 => for connection to SQL Developer and MS SQL Server DTS http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
2. install 32bit Oracle 11gR2 ODAC in Oracle Home 2 => for connection to Access 2007 or older technology http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html

Related Links:

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/01/26/connectivity-issue-with-oracle-in-x64-environment-ora-12154-tnscould-not-resolve-the-connect-identifier-specified/

https://oracle-base.com/articles/misc/manual-oracle-uninstall

http://superuser.com/questions/713258/how-to-remove-odbc-data-source-if-driver-is-removed