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

The issue is most likely DNS. Whatever DNS server your Android device is using, doesn't include a listing for www.myserver.

If that DNS server is one you control, you can add a manual entry for that host. Otherwise it may be simpler to work around it by using the server's IP address e.g. http://192.168.xxx.xxx/MyApp

It seems there is a Hosts file for Android, just as for Windows PCs. You could add an entry there, then you'd be able to get to your local server using http://myserver/myapp. Google [hosts file for android].