How to deploy x86 compile code on SharePoint server 2010 ( x64)

I'm creating visual web part project which connects Oracle database using ODP.NET. When I deploy on SharePoint server 2010 , web part gives Oracle dll missing error. Even I tried to compile in x86 or Any CPU but it gives error. Here is the error,

SharePoint server 2010 is running on my machine whereas Oracle server is running on different machine. I've verified the code in nor开发者_高级运维mal ASP web application and it successfully connects Oracle server.

Any thoughts?

SharePoint 2010 is 64-bit only.

SharePoint 2010 is a 64bit process, so it can only load x64 or Any CPU assemblies.
Be careful that all your assemblies, and all dependencies, have to be x64 or Any CPU.

In your case, I guess you linked to a x86 version of the Oracle assembly. You'll have to install Oracle in x64 mode.