Dirt McStain (10/26/2010)
i don't have it in front of me, but there is a 64-bit ADO.NET driver. I don't remember what it comes up as in the menu, but it's there and it works in 64 bit without any problems for me. When I was testing out different versions of Oracle client, I remember that I ran into some problems. Installing Client 11g R1 32-bit alongside the 11g R2 64-bit driver cleared up all of the issues. The biggest problem is that you need the 32 bit driver while developing in BIDS but the jobs run in 64-bit mode. Installing the R2 32-bit driver caused a lot of problems, so I ended up using R1 instead.
Now i have a hope that 64 bit (Ado.Net) drivers exist for 11g Oracle.. I did an exhaustive search and downloaded all that i found with x64 from the oracle site. If you can leak out your installation procedure and post installation steps it could help me to find where i went wrong.