>>>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.