If I understand you, the requirement driving your desire to also save into a database is being able to query and report?
If so, I think you might be over architecting. Then again, I'm a believer in KISS, so maybe I'm over simplifying. Why not just use SQL Server Reporting Services to query/report on the list(s) being populated by the InfoPath form? You can expose the SSRS via a web part on another site, or even on the same site. See http://msdn.microsoft.com/en-us/library/ee633650.aspx Kevin On Mon, Jul 2, 2012 at 6:42 PM, S Powell <[email protected]> wrote: > SharePoint 2010 and InfoPath 2007. If any of you can help me figure > out how to do this, or can offer an off-list consult, I'd be grateful: > > here is what we have layer out. > We have an InfoPath template hosted on our SharePoint site. Teams > open the template in a browser, this generates a form that is filled > out to create meeting agendas; the filled out form is then saved to > the SharePoint site. > We would like to have this form, as filled out, saved on the site; as > well as having the data from that form saved into a database or > otherwise be available for searching (not just SharePoint’s search but > also being able to generate reports from the data contained therein) . > It does not need to happen in that order; but we do need to have both. > > This is really the most important issue, that the information can be > queried. > > Our users are using IE9 or Safari to fill out the forms, and according > to Microsoft, a web form cannot be saved to a database, but only to a > form or a web service. > --“To configure a browser-compatible form template to submit data to > a database, use a data connection that submits data to a Web service > that works with the database.” > > Are there web services that we can use (and how do we use them) to do > this? What we need is something that will be happy to generate the > form for our users to view, and still have the data that can be > queried? > Here is the workflow; starting from a template, filling it out online > in a browser compatible format then saving the form and getting the > data in to a database to be queried. > > > > ----------------- > "Choose the highest bidder" was my answer when they told me I was up for > sale. > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
