Last post Jan 15, 2018 05:30 PM by Lannie
Jan 15, 2018 04:25 AM|shsu|LINK
In VS 2010 ,Showing version error while submitting in local host, when publishing to server it is working .How to solve this
Jan 15, 2018 01:54 PM|PatriceSc|LINK
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.
Jan 15, 2018 05:30 PM|Lannie|LINK
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.