We need to access a view on a 32 bit Oracle 9i - Release 126.96.36.199.0 database running on Windows 2003 Server, from a MS SQL 2008 R2 64 bit system running on Windows Server 2008 64 bit.
We tried installing the Oracle 10g client (10.2.0.4) on the MS SQL server and received version errors; it did install after telling it to ignore system prerequisites. After the install we still cannot get the OraOLEDB.Oracle provider to appear in the providers list. We did see that the 10.2.0.5 patch might help, but do not have immediate access to download it.
The DBA for one of the vendors involved has concluded that it is not possible to link from 64 bit MS SQL to a 32 bit Oracle install. While, I am definitely not a database expert, this just does not sound right to me.
I would welcome input on how to make this connection and on whether or not it is even possible.