64 Bit ASP.NET Project. Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

Revision 1
I am getting a "Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed."

I have a main ASP.NET project which is 64 bit(set to Auto though) and another oracle database project 64 bit(set to Auto). I am getting the above error in "Connection.open()' in the oracle database project. I am using System.Data.Oracle client, the 64 bit version-2.0.50727.5420

There are the things i did. It did start working randomly at some point but then something happened and it is not working anymore. I thought I fixed it but i cannot be sure if I did. These are the things I fixed-.

1. Removed all 64 bit references from my projects. Added 64 bit dll references from Windows\Microsoft.Net\2.0*\.NETFRAMEWORK64.

2. Added 32 bit enabled support in my Application pool in IIS7.

3. When i run the project, I still get the& 'Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed


Has anybody had any success with this?

Anybody have suggestions. I could make my whole project x86 but then I am using a 64 bit server processor..so it seems bad.

Should I download Orcale Data access provider from Oracle and try it? Its supposed to be 64 bit.

Any suggestions will be much appreciated.

Thanks
Jobin Thomas