Here's this scenario, I have connection to the VPN via ODBC, and at the same time I also have Excel files as back-up datasources. What will happen is that, whenever I got connected to the VPN, I want my application will load data coming from database, and when the VPN is down or disconnected - my application will read data from excel files.
Example algorithm,
If ODBC = CONNECTED
get data from database
Else
get data from excel file
End if
Please help me solving this problem. Thanks in advance.
