https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/87436.aspxTue, 26 Feb 2013 16:56:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:87436jbrandenburg0https://www.infopathdev.com:443/forums/thread/87436.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=87436Resolved: I am utilizing SSIS to transfer my data into a SharePoint list. This keeps the functionality offline available. Thanks! Jessehttps://www.infopathdev.com:443/forums/thread/86836.aspxThu, 07 Feb 2013 15:13:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:86836jbrandenburg0https://www.infopathdev.com:443/forums/thread/86836.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=86836Hi Patrick- Thank you for your response. I think I am going to look into a custom timer job to copy the sql values into my SharePoint list nightly. Jessehttps://www.infopathdev.com:443/forums/thread/86586.aspxTue, 29 Jan 2013 23:20:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:86586Patrick Halstead0https://www.infopathdev.com:443/forums/thread/86586.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=86586<p>Hi Jesse and welcome,</p><p>SharePoint Workspace doesn&#39;t officially support InfoPath because of these data connections. </p><p>We have built solutions for connecting to SQL and synchronizing offline - take a look at Qdabra&#39;s DBXL Client product. It&#39;s inexpensive and works well for your specific scenario when coupled with DBXL Server, but it might be overkill for your scenario.</p><p>If they have the form already and are simply taking the form offline to fill out, you could copy the SQL values into the form and then have two controls - one for offline and one for online. This won&#39;t work for new forms.&nbsp;We have solutions for this too. </p><p>Please let me know if you&#39;d like to see either of these solutions and we can arrange a demo.</p><p>Sorry&nbsp;I didn&#39;t have a super easy silver bullet for you.</p>https://www.infopathdev.com:443/forums/thread/86324.aspxWed, 23 Jan 2013 18:09:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:86324jbrandenburg0https://www.infopathdev.com:443/forums/thread/86324.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=86324Hi- I am using SharePoint 2010/InfoPath 2010 I have brought in data via BCS from a SQL DB. I would like to create a form for another list in SharePoint that looks up data on this list while maintaining offline use in SharePoint Workspaces. I have tried creating the list as a data source, and setting the choices to be the fields I need, which works, but as soon as I bring it offline, the form stops working because it cannot retrieve the data directly from the source. I would like to make the look up values behave the same way regular list lookups work (they are functional offline) if I sync all lists with workspaces. Has anyone tried to do this or know how to make this work correctly? Thank you in advance for any assistance, Jesse