General

Re: Send all fields to a database table when the form is submitted

buzzby — Thu, 17 Dec 2009 17:24:53 GMT

Thanks, thats what I thought.

Re: Send all fields to a database table when the form is submitted

warrtalon — Thu, 17 Dec 2009 14:54:35 GMT

To submit to SQL from a browser form, you'll have to use a web service between the form and SQL. You'll also need to do a lot of permissions work by converting that web service data connection to a Universal Data Connection using the DAta Connection Library, and you'll have to modify the contents of this UDC file to leverage a Single Sign-On entity that you make in Central Admin. That way, credentials of your users can be impersonated to the DB and passed through the double hop across servers from the browser form.

Once you do that, you basically map all your fields to the web service to tell it which fields to submit to SQL upon clicking submit.

Send all fields to a database table when the form is submitted

buzzby — Thu, 17 Dec 2009 09:23:36 GMT

Hi I have a browser forms in a share point form library. This is a large form with around 14 views, so quite a lot of fields. The client i am writing this for has an unspecified reporting requirement and a requirement for the form data to be made available to other systems. The client requires all of this information to be stored in a SQL database table so they can query the data how ever they like. My question is: Is there an out of the box way of sending all of the fields to a database while still using the submit connection i have to save the form to sharepoint. I can write this myself in some C# code to send all the fields to a stored procedure or something but want to see if info path can do the grunt work for me. Thanks in advance