I'm trying to host the .net web application developed on .net framework 4 32bit. on moving to the production machine which is 64 bit and so installed ODP.net for 64 bit version
The steps followed in the installation were
1.Installed the ODP in oracle home path
2.Added the entry in machine.config using the exe provided
The version of the ODAP installer is 64-bit ODAC 11.2 Release 5 (22.214.171.124.20) Xcopy for Windows x64 [Released September 12, 2012]
on launching the application works fine and got the below exception when trying to query which uses entity model
Exception Type: System.Data.ProviderIncompatibleException
Exception: The store provider factory type 'Oracle.DataAccess.Client.OracleClientFactory' does not implement the IServiceProvider interface. Use a store provider that implements this interface.
A couple of potential problems:
1. It may not be installed correctly on the server. That's a common problem I see with people using the xcopy version.
2. If your applicaiton is running in 32 bit mode, you need the 32 bit ODP.net. It won't work with the 64 bit once unless you change the application to be 64 bit (or AnyCPU).