InfoPath Dev

Hi all,

I am currently investigating the possibilities of storing my xml forms. When users fill out my form, I want to push the xml data to a repository or data store. But I do not know what the best solution would be.

I have contemplated (knowing my organisation endorses Microsoft products):
Microsoft SQL Server
Microsoft Access
or just a simple file structure on a web server.

Basically the purpose of this is for us to query and generate statistics later. Can anyone help?

Hi,

If you can, go with SQL Server 2005, which provides the XML support that you are looking for:
http://yukonxml.com/weblog/darshan/archive/2005/02/24/227.aspx
http://www.developer.com/db/article.php/3531196
http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=45131&DisplayTab=Article


Regards,

Franck Dauché

Hi Qwer,
Our Database Accelerator provides a no-code solution to store InfoPath forms in a SQL DB. It supports multiple forms and is configurable.

Patrick Halstead [InfoPath MVP]
InfoPathDev