Using Oracle DB from C#-VS2005

Oracle installed on the server is 10.2.0.3 Enterprise Edition 64bit (10g).

ODAC is showing version as 10.2.0.2.20 is on a Windows 2008 x64 machine.

Error I run into when I run my app in my test environment in above machine is

The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.

I tried using .Net Oracle namespace and I get this using a version from C:\Windows\Microsoft.NET\Framework64\v2.0.50727

Error:

Oracle client libraries threw 开发者_开发技巧BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

Anyone run into such an issue?

Also what is the right Oracle Client/ODAC to use on Windows 2008 x64 machine? Anyonen have a link?

You seem to have installed the 32 bits Oracle client, or you must have a 32 dll masking your 64bits client. You need to install the 64bits client so that 64 bits dll can be accessed by your app. Look for an oci*.dll in your path.

Also look into the registry under hklm\software\oracle to see how many 'homes' you have.

Finally if you have toad on that client look at the home selector in the connection dialog box. It will show incomplete or inoperative homes in red.