>>>>I need to write an application that can run on an Android device allowing data to be downloaded from a SQL Server 2012 database, updated on the device and then sent back to the SQL Server database.
>>>>
>>>>Does anyone have any experience doing this and can recommend tools to use?
>>>
>>>
>>>So the device is presumably wirelessly connected to your local network at the beginning of the day, and then the driver leaves and they are no longer connected?
>>>
>>>Create a dynamic web page to get the required data and serve it as JSON.
>>>
>>>The Android app can easily read the JSON, and store it in its own local database, a SQLite database to be precise (every Android App has its own SQLite database).
>>
>>Thanks for the idea. I will investigate it more fully.
>>
>>One thing that confuses me is I have IIS running on a server in my office network. I tried to use my Android phone to access the URL for a site running on that server (http://myserver/myapp) but it fails, it seems to go looking on the internet for the site rather than connecting to the site here. Is there something I need to do to let an Android device connect to my server?
>
>What first comes to mind is that you're on mobile data, instead of WiFi. Can you get to it from a laptop on the same WiFi?
>
>Try turning the mobile data off.
Nope, definitely on WiFi, double checked by switching off data.