InfoPath Dev

If I needed forms to interact with a SQL Server database but also be saved locally in case an internet connection is not available what would be the best solution? Should I research on how to use a web service to bridge InfoPath to the SQL Server? What happens when an internet connection is not available? Can they save the forms locally and then publish them to the SQL Server when internet is available? Finally, could I have some resources either books or blogs that would help implement this? I have developed several ASP.Net applications so I am not new to .Net coding but I haven't used web services very much at all. Thanks.

Hi - you might want to explore on Qdabra's DBXL Web Services. Here's a demo video that shows how it integrates with SharePoint and SQL. We also have a client version for offline solutions which I believe is exactly what you're looking for. Users can fill out forms while offline (forms submit to the local DBXL and/or SQL) and then sync to the server when they come online. You can check out the free trial to find out if it's indeed the solution you want.