We have an application that communicates with an Oracle database and uses a MS SQL database to manage the data and present it to a web page. The issue is that whenever we access a page that requires data from SQL via a linked server connected by the OraOLEDB.Oracle provider an error is thrown. "Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed". This seems strange in that all the drivers have been loaded using the 64bit installation from Oracle for the complete Client (Administrator Tools option).
The Linked server on SQL 2008 R2 enable us to run queries successfully on the Oracle 11gR2 database.
All servers are W2008R2 64 bit (Web, Oracle 11gR2 and MS SQL2008R2)
Any suggestions for fixing this error?
We have tried installing the Oracle 32 bit Client but this does not seem to make any difference.