Save InfoPath 2010 browser-enabled form to SharePoint Lib & SQL Server? RRS feed

  • Question

  • Hi, I'm currently new to InfoPath 2010. I have a task to create a browser enabled form using InfoPath 2010 and save data to SharePoint Foundation 2010 & SQL Server 2008. Through the research I found from many forum, it require to create/use a web service(as middle man) to connect to SQL Server.

    May I ask how to create a web service for all my forms and how the procedure like to submit my form correctly to both?

    Is there any way to display a Excel format of full summary of the data being save in SharePoint?


    Thursday, September 6, 2012 3:22 AM


  • In order to leverage an InfoPath browser-enabled form, you must have SharePoint 2010 Enterprise.  See http://sharepoint.microsoft.com/en-us/buy/pages/editions-comparison.aspx ("InfoPath Form Services" is the feature).


    • Proposed as answer by Ivan-Liu Wednesday, September 12, 2012 8:05 AM
    • Marked as answer by Trevor SewardMVP Wednesday, August 21, 2013 9:50 PM
    Thursday, September 6, 2012 3:32 AM
  • You won't be able to use it on SharePoint, IFS is required in order to use web browser enabled forms.  I would suggest you download the SharePoint 2010 Enterprise trial (http://technet.microsoft.com/en-us/evalcenter/ee388573.aspx).

    You can use a client-enabled form (requires the client to have InfoPath client installed) with Foundation.  You don't need to use a web service, as far as I'm aware, to connect to SQL Server, but just standard data connections and depending on what you're doing, VBA.


    Thursday, September 6, 2012 3:47 AM

All replies