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

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?

Thanks!

Answer 1

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).

---

http://sharepoint.nauplius.net

Answer 2

Hi Trevor,

Yes, I noticed too but we haven't bought the Enterprise version yet so using Foundation ver. to test. If I just save as web browser form & use InfoPath to fill in. Can I still continue to work on saving data to sql server & sharepoint lib? Now currently I'm able to save my form into SharePoint Library.
Thanks!

Answer 3

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.

---

http://sharepoint.nauplius.net

Answer 4

Ok, but from http://www.infopathdev.com/forums/t/16428.aspx & http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/b5f04e54-158e-4159-bae6-efd32311ebd3 its doesn't seem like standard data connections can do it.
 Actually I'm need to create quite a few form, one particular form is to allow user to inside their Personal Particular. So after submitting, it will send to HR and proceed for approval.

Thanks!