Hi everybody, I need very urgent help here.
I have an application written on vb2008 using odpNet to connect to the Oracle Database. The application consist of two parts. One is a client part interacts with client the other part is a Windows Service Application.
Both parts target "AnyCPU" which means runs on both 32 and 64 bit Operating Systems.
Both parts run on the same machine which runs on virtual 64bit Win10
Client part works perfectly and connects the Oracle database with the same exact connection method which is odpNet
But service part gives "Could not load file or assembly 'Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format." error when it connects to the Oracle.
I have one Oracle Home, Path is correct and points to the valid Oracle Home directory.
I tried deleting Policies from GAC that didn't help also.
I searched and tried all the suggestions from Google, Stack Overflow etc.
Now I'm stuck and I need to hand this project very soon.
Any help is welcome, thanks in advance.