Ask a questionAsk a question
 

AnswerBest intermediary between Form Services and a database?

  • Thursday, November 05, 2009 8:56 PMSean Sharepoint Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    As you all know I'm sure, submitting form data via forms services to a database is not supported. What is the best intermediary in order to use browser-enabled forms with forms services and submit form data to a database?

    Sharepointers.... Go!

    • Changed TypeSean Sharepoint Friday, November 06, 2009 1:22 AMIts not a discussion
    •  

Answers

  • Thursday, November 05, 2009 10:17 PMSrinivas Varukala Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Submit to a web service and the web service will take care of saving to DB and/or file system and what not!
    Srinivas Varukala http://sharenotes.wordpress.com

All Replies

  • Thursday, November 05, 2009 10:17 PMSrinivas Varukala Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Submit to a web service and the web service will take care of saving to DB and/or file system and what not!
    Srinivas Varukala http://sharenotes.wordpress.com
  • Thursday, November 05, 2009 11:53 PMClayton Cobb Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sean, please change this to a question - it is actually a question - that way people can get credit for answering.  I can't propose svarukala's reply as an answer due to this.

    I thought using a web service was the obvious choice - it's the recommended method even if you have a rich client form.  You should not ever connect directly to the DB - should always be a web service anyway.  Using a web service will allow you to read from and write to a DB directly, although it also requires a bunch of other security steps to allow for the double hop and authentication impersonation.
    SharePoint Architect || My Blog