I am developing a software which will connect to a SQL SERVER situated at Head Quarters over a VPN connection.But for times when VPN is disconnected I want my applications at the branches to connect to a local Sql Server installed at a local server.
Now all the applications at each of the local machines have their connectionstring stored in their App.config file.
When the VPN is disconnected we have to change each of the connection strings on all the applications in each machine. Is there a way to do it automatically switch the connection string depending on whether the Server is reachable or not, and to store the connectionstring at centralised location. Someone told me that .Net remoting might due the trick can someone share more light on it and is there a simpler solution.
And How can i constantly check whether the Server at the H.O is reachable or not without using too much resource ?
I am using VB 2008 and SQL SERVER 2008.