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