Hi, I've seen a lot of questions about this but no definitive answer and after a few days of jumping around I thought I'd take a post at this. I have writing reports on a Windows 7 x64 machine using VS2008 BI Studio. My local SQL report server is a SQL Standard 2008 R2 install (x64). I have an Oracle connection on my machine, I have installed both the 32-bit and 64-bit installations of ODAC (and the Visual studio tools). When I am working in Visual Studio I am able to write reports, create parameters and write some queries, all against a 32-bit ODBC using my OracleHome dir. For some reason after doing all of the above installs I never see the Microsoft OLEDB Provider for Oracle in either my 32-bit or 64-bit ODBC Administrator Tools. When writing reports, I can preview them and get data (AWESOME), however when I go to view them in Reporting Services (via IE) I always get the Bad Image exception for the Oracle Drivers. I have tried running IE in either a 32-bit and/or 64-bit mode and still no luck. Anyone know what steps I have missed or am doing wrong? I know the whole 32 vs 64 adds a layer of complexity, but my production environment is going to be a Win2008R2 x64 box so I might as well deal with this now. Thank you. Greg.

Hi Greg_AD, For further investigation, please post more detail error log information when you view the report on the Report Manager. By default, the log information locate in <drive:>\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles. Currently, the data processing extension OLE DB for Oracle does not support the following Oracle data types: BLOB, CLOB, NCLOB, BFILE, UROWID. There are some articles about accessing and configuring an Oracle data source for your reference: How to use Reporting Services to configure and to access an Oracle data source: http://support.microsoft.com/kb/834305 Reporting Services may not be able to run reports against Oracle databases: http://support.microsoft.com/kb/870668 Retrieve Data from an Oracle Data Source: http://msdn.microsoft.com/en-us/library/cc627448.aspx Regards, Bin LongBin Long TechNet Community Support

Cool man... thanks.

Hi Greg_AD, For further investigation, please post more detail error log information when you view the report on the Report Manager. By default, the log information locate in <drive:>\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles. Currently, the data processing extension OLE DB for Oracle does not support the following Oracle data types: BLOB, CLOB, NCLOB, BFILE, UROWID. There are some articles about accessing and configuring an Oracle data source for your reference: How to use Reporting Services to configure and to access an Oracle data source: http://support.microsoft.com/kb/834305 Reporting Services may not be able to run reports against Oracle databases: http://support.microsoft.com/kb/870668 Retrieve Data from an Oracle Data Source: http://msdn.microsoft.com/en-us/library/cc627448.aspx Regards, Bin LongBin Long TechNet Community Support

Hi Greg_AD, For further investigation, please post more detail error log information when you view the report on the Report Manager. By default, the log information locate in <drive:>\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles. Currently, the data processing extension OLE DB for Oracle does not support the following Oracle data types: BLOB, CLOB, NCLOB, BFILE, UROWID. There are some articles about accessing and configuring an Oracle data source for your reference: How to use Reporting Services to configure and to access an Oracle data source: http://support.microsoft.com/kb/834305 Reporting Services may not be able to run reports against Oracle databases: http://support.microsoft.com/kb/870668 Retrieve Data from an Oracle Data Source: http://msdn.microsoft.com/en-us/library/cc627448.aspx Regards, Bin LongBin Long TechNet Community Support

Hi Greg, Thank you for your question. I am currently looking into this issue and will give you an update as soon as possible. Thank you for your understanding and support. Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Bin Long TechNet Community Support

Hi Bin, Those articles are direct errors into Oracle, I cannot even get that far as I cannot seem to load the dll. Here is a latest deployment test; - Windows 2008 R2 SP1 (X64) - Oracle 32 bit drivers - ODBC 32-bit connection - Running IE in x86 mode This is the error I get when I try to "Test" the connection. ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application Thank you.

Managed to finally get this working today. I followed this blog post (for me I went up to the steps before "Post Oracle Client Installation") and it worked fine. Users can execute reports using either IE x64 or IE x32. Greg.

Greg_AD, What blog post are you referring to? Can you share the link? Thanks.