SQL Database Integration

Re: Can I save data in SQL Server using InfoPath?

smithringers10 — Sat, 02 Jun 2012 00:02:01 GMT

Can I display the info in a regular view? In the end, I want a form library that stores data in a SQL Server DB.

Re: Can I save data in SQL Server using InfoPath?

molierrejacke14 — Thu, 19 Apr 2012 17:47:24 GMT

Re: Can I save data in SQL Server using InfoPath?

EmmaRoberts — Sun, 18 Mar 2012 04:40:23 GMT

Yes, you can do this. For a browser-enabled form you will need to create a webservice to be the middle man between the InfoPath form and the database. I'm not sure if I asked you this before - but do you have any programming experience? I used the following to teach myself how to create a webservice for my InfoPath forms: http://www.bizsupportonline.net/infopath2007/how-to-submit-repeating-table-infopath-web-service.htm Melissa

Re: Can I save data in SQL Server using InfoPath?

Ramon84 — Sat, 10 Dec 2011 02:18:11 GMT

Thank u very much! :)

Re: Can I save data in SQL Server using InfoPath?

ErnestoM — Thu, 08 Dec 2011 13:53:25 GMT

Hi-

If you want a browser-based, InfoPath form that submits data to SQL, you'll need code, you'll need a web service, or you'll need a third party tool. This has been discussed previously, such as here, here and here. This is a good read as well.

Good luck!

Can I save data in SQL Server using InfoPath?

Ramon84 — Wed, 07 Dec 2011 15:45:23 GMT

Hi, I need some guidance, please.

First all of, I am running MOSS 2007 SP2 and MS InfoPath 2010

I want to know if I can create a browser form to save information into a SQL Server. If so, how can I do that? Basically, SharePoint & InfoPath will be the interface between the user and the DB. Can I display the info in a regular view? In the end, I want a form library that stores data in a SQL Server DB.

Thanks in advanced