Which ODAC for 32 bit dev and 64 bit deployment
554010Sep 15 2008 — edited Jul 12 2011
We have an environment where the developers work on 32 bit windows workstations using VS2005. The assemblies are created using a specific version of Oracle.DataAccess.dll, in this case 10.2.0.100. When these assemblies are deployed to the 2003 server they are intended to run as 64 bit assemblies.
Here is the problem, I can not find the 64 bit version of Oracle.DataAccess, version 10.2.0.100. There are versions of ODAC, 2.102.3.2 for example, that work in 64 bit processes but there is no possibility to use that version for coding and debugging.
What is needed is a Oracle.DataAccess.dll that has BOTH a x86 and AMD64 versions. Is there such a thing?
What does Oracle recommend when developing in 32 bit environments and deploying to 64 bit environments?
If we test on 32 bit and then recompile with the 64 bit ODAC this works, but there is no operations group that is going to let you get away with that. The tested assembly needs to be the one that is actually deployed to production.