locked
Oracle version error -C#.NET RRS feed

  • Question

  • User-1578974752 posted

    In  VS 2010 ,Showing version  error while submitting in local host, when publishing to server it is working .How to solve this

    Monday, January 15, 2018 4:25 AM

Answers

  • User753101303 posted

    Hi,

    Not using Oracle but generally speaking:
    - it is easier to help starting with an actual error message (or the best English translation you have)
    - for now it looks maybe like https://oradim.blogspot.fr/2009/09/odpnet-provider-is-not-compatible-with.html ?

    Make sure to use the same version on localhost and on the machine to which you publish to avoid this kind of error. Usually it is the other way round ie you write your app and then you realize at the last minute that what you have on the test/production machine doesn't matches what you used for development.

    So always do a version check when starting to work on something.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 15, 2018 1:54 PM

All replies

  • User753101303 posted

    Hi,

    Not using Oracle but generally speaking:
    - it is easier to help starting with an actual error message (or the best English translation you have)
    - for now it looks maybe like https://oradim.blogspot.fr/2009/09/odpnet-provider-is-not-compatible-with.html ?

    Make sure to use the same version on localhost and on the machine to which you publish to avoid this kind of error. Usually it is the other way round ie you write your app and then you realize at the last minute that what you have on the test/production machine doesn't matches what you used for development.

    So always do a version check when starting to work on something.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 15, 2018 1:54 PM
  • User269602965 posted

    Oracle was installed on a specific IP address on your local system.  Your tnsnames.ora must point to that IP address.  The problem is, if the IP of that adapter changes, well Oracle will be lost.  So follow the Windows installation recommendations for a local installation of Oracle, such as a development workstation.

    For installing locally on Windows.  Oracle recommends installing the  Microsoft Loopback Adapter and give is a loopback IP like 192.168.200.5.  Something not used by your WIFI or LAN network adapter.  Then configure that Loopback Adapter with IP 192.168.200.5, mask 255.255.255.0, gateway no value, and DNS 127.0.0.1 (local host).  Then in the HOSTS.INI file create a hostname like local.data and assign IP 192.168.200.5.  place this entry before the localhost 127.0.0.1 found in default HOSTS.ini file.  Now when you go to install Oracle, turn OFF your WIFI adapter and turn OFF your LAN wired adapter, but leave the Microsft Loopback Adapter ON.  Now install Oracle and tell it to use local.data for the domain name which maps to the 192.168.200.5 address.  When Oracle installs successfully, you can reboot and turn ON your WIFI and LAN adapters.  Now Oracle will work INDEPENDENT of the WIFI and LAN IP addresses, even if they change, Oracle will still be on the Microsoft Loopback Adapter 192.168.200.5 address.

    https://docs.oracle.com/database/121/NTDBI/network.htm#BHCEABAE

    Monday, January 15, 2018 5:30 PM