ODP.Net 11g 64Bit 3.5 framework
689193Mar 5 2009 — edited Mar 5 2009Hello,
We have an application that was previously a 32 bit application running on the 3.5 .net framework and was working just fine with the Oracle.DataAccess version 2.111.6.20. When we went to run this on a 64 bit (no recompile since the app is compiled to target any cpu) we ran into issues where we would get "Wrong. BadFormatExceptions from Oracle.DataAccess" in our event logs. After much searching I came across this blog that describes the issue exactly.
http://tiredblogger.wordpress.com/2008/11/06/getting-oracledataaccess-working-on-x64/
After following the directions and downloading the 11.1.0.6.0 client from http://www.oracle.com/technology/software/products/database/oracle11g/111060_win64soft.html we have everything working. Only problem is performance is rotten compared to the 32bit (2.111.6.20) driver.
Performance wise our application has to make several calls per minute to Oracle and we have seen the time go from around .02 seconds round trip to about 1 second per call.
If anyone has any information on how to get a better driver or a fix for this it would be great.