1 Reply Latest reply: Sep 11, 2012 12:45 AM by sivaraj seeman RSS

    How to condition if connected to ODBC?

      Hi,

       

      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.

       

      Best Regards,

      Bill