SSRS to Oracle 64 bit vs 32 bit patch
I have one server running Windows Server 2003 R2 and SQL Server 2008 x64 with Reporting Services. I am creating a report from within BIDS which uses the 32 bit (x86) directory. This report points to an Oracle 10g 10.2.0.3.0 database on another server running Server 2003 R2. The problem is that reports do not run since the Oracle client does not like the special characters x86 in the path name.
I have downloaded both 64 bit and 32 bit Oracle client which did not resolve the issue. I have copied the Visual Studio 32 bit directory to a folder with no special chacters in the name ("C:\Patch\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe") and can now run the report successfully when using the new devenv.exe. However, once uploaded to the server, I cannot run the report remotely. Researching the issue, it looks like I need to apply two patches. However, these patches say to only install them on 10.2.0.1. I am on 10.2.0.3. Can I install these patches even though I am at a higher release? If so, is this suppose to be installed on the database server? Or on the SSRS server where I am using the client?
5059238 - Patch for (x86) issue
4751549 - "opatch
http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/f0de2e77-aa54-4d60-be4f-fe95e80405f1/