Oracle client 32bit/64 bit
I have a Windows 2003 SP2 64 bit server running Microsoft SQL Server 2008 R2 64 bit. There is an application that runs on the server that requires a 32 bit ODBC connection to an Oracle 10.2.0.3 database and the SQL server requires a linked server to a Oracle 11g database. What is the best/supported way to do this?
Thanks
Michelle