I saw couple post under thread and few people had the same issue what I have in order to create the data source for oracle database from BIDS 2008/SSRS 2008 to create the new report.
My Machine is windows 7 64-bit with Oracle 11g R2 client(runtime) installed. Also has SQL Server 2008 R2.
This is the message I get when I try to create data source for Oracle from BIDS,
"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."
If anyone has solution, please provide with enough detail. I would appreciate it.
Thanks Greg for quick reply...
It seems that Visual Studio is 32-bit process/program but now the problem is when I try to install Oracle 11g 32-bit Client on my Windows7 64-bit Oracle Universal Installer fails. It doesn't allow to install 32-bit oracle client on my 64-bit windows machine.