Re: Beginning of building an information grabbing form for SharePoint 2010

ErnestoM — Fri, 10 Dec 2010 11:27:50 GMT

Submitting to SQL is a classic InfoPath problem. Here's what was discussed in an earlier thread:

If you create your form using an XML Schema (File->Design...->New from Blank) you can't submit directly to a DB. That's because the schema is XML and not based off SQL data types. Submitting directly to a DB after form creation was never an option in InfoPath.
If you create your form from a DB, you already have the submit data connection built in.
Best practice here is to submit to a Web Service as an XML string. Have the Web Service handle the mapping to SQL. Then, one Web Service can handle any form. This is the way Qdabra's Web Service Suite (DBXL) works. Free downloads and very inexpensive licenses will save you a lot of time and money.

I found other previous discussions which all point to similar solutions:

(a) You create a db-bound form.

(b) You write your own web service.

This is a great post which covers b and c. Good luck!

Beginning of building an information grabbing form for SharePoint 2010

Hotdogwater — Thu, 09 Dec 2010 18:17:17 GMT

I'll explain what I'm trying to do. I want to create a new user form, so a manager can fill out what their new employee will need in the form of access. Not all the managers have infopath. I want to tie the submits to a SQL 2008r2 database, but I don't know a thing about programing a web service. Why can't it be as simple as making an OBDC on sharepoint to the sql server?! anyone have a web site explaining a basic web service linking it to a sql database with one table?

Newbie Questions

Re: Beginning of building an information grabbing form for SharePoint 2010

Beginning of building an information grabbing form for SharePoint 2010