Offline Infopath 2010 forms using Web Service data

jpollick — Tue, 10 Jan 2012 00:23:23 GMT

We're trying to figure out how to make InfoPath 2010 forms that can work with local/offline data, which we originally get from a Web Service. We have made sure that the data connections store copies of the data in the template, and where appropriate, Automatically retrieve data when the form opens. We've also made sure that the options to "Allow users to fill out this form if data is unavailable" and "Store data returned from queries so it can be used in offline mode" options are checked.

The problem is that when we open a saved form in offline mode, it still looks for the Web Service and then fails instead of looking for the locally stored XML.

The data comes from a relatively large and complex SQL database and we need to use it to populate drop downs through the use of code-behind in the forms. We have kind of hit a wall when it comes to a good way to do this. We would rather not use a local database that replicates the one used by the Web Service. Also, we need the local data to be refreshable when the Web Service is accessible so that it is current with the online data when the forms are submitted to their eventual destination.

Any help on how to access the offline XML is greatly appreciated. Thanks.