This content has been marked as final. Show 3 replies
It depends on the client, and more specifically what the application is running as. The server has no impact.
A 32 bit application requires the 32 bit client, and a 64 bit application requires the 64 bit client.
So... on your 32 bit XP machine, you need a 32 bit client. Assuming it's a .net application, you'll need to compile it in AnyCPU (the default) or x86 mode.
On the 64 bit production machine, you need a 32 bit client if you are running a 32 bit application (compiled as x86). You'll need a 64 bit client if you're running a 64 bit application (compiled in AnyCPU or x64 mode).
With that in mind, what you want to do if it's a .net app is just build it in AnyCPU mode. Install 32 bit ODAC on your dev machine and 64 bit on the production one, and make sure the version numbers on the two match. Make sure Copy Local = False on your Oracle.DataAccess.dll reference, and it should all work as you want it to.
Edited by: Tridus on Feb 8, 2013 8:02 AM
Thanks a lot! Sorry for the slow response - as I was caught in a travel situation with snow...
In addition to what Tridus said, we also have a fully managed provider (currently in beta) that does not require you to change anything when you move from a 32 bit platform to a 64 bit platform.