6 Replies Latest reply: Oct 5, 2012 11:48 AM by 243257 RSS

    Win 2003 32bit vs ODP.NET: The provider is not compatible with the versi...

    243257
      Hi Guys,

      Maybe this is a boring topic for you, I've checked several posts, tried many things, no success. On my DEV environment everything works, on the TEST env I cannot connect to oracle, I get: "The provider is not compatible with the version of oracle" error. Here are my environments:

      DEV env:
      win 7 Prof SP1, 32 bit
      .Net FW 4 client profile, .Net FW 4 Extended, .Net FW Multi-Targeting Pack
      ODP.NET4 (11.2.0.3.0)
      Visual Studio 2010

      TEST env:
      Win 2003 Server R2 SP1, 32 bit
      .Net FW 2.0, .Net FW 3.0, .Net FW 4 client profile, .Net FW 4 Extended
      ODP.NET4 (11.2.0.3.0)


      On the TEST env I uninstall the oracle driver I get: "Unable to find requested .NEt Framework Data Provider. It may not be installed" which is good, since no driver is installed.
      If I install ODP.NET2 I get the same: "Unable to find requested .NEt Framework Data Provider. It may not be installed"
      If I install ODP.NET4 I get: "The provider is not compatible with the version of oracle"
      Each time I check the registry and it looks good, only one driver is installed.

      I've tried to copy the oracle driver dlls next to my dlls, same result - in case of ODP.NET2 I get "the provider is not comp..." error.

      What else can I do, any idea?

      thanks,
      fifty