Newbie Question: Data storage/retrieval

[Chris W]

We don't have Infopath but I was asked to do a little research...where does
Infopath store the user data entered through a form? In SQL Server or can the
developer choose a different data source such as ORACLE, DB2 or MS Access
etc? Same question for data retrieval? How about retrieval options? Is there
support for stored procedures?Any info or re-direct to another source would
be appreciated.

 

[S.Y.M. Wong-A-Ton]

InfoPath stores data in XML or a database. SQL Server and Access are
supported by InfoPath, i.e., you can bind a form directly to either one of
these databases. Other databases such as Oracle can be accessed through web
services.

The same goes for data retrieval. Full support for stored procedures can be
achieved through managed code in InfoPath or by calling them through web
services.

Some resources for more information:
http://msdn.microsoft.com/library/en-us/odc_ip2003_ta/html/odc_inArch.asp?frame=true

http://msdn.microsoft.com/library/e...OfficeInfoPathWebServiceASPNET.asp?frame=true

http://msdn.microsoft.com/library/en-us/odc_ip2003_ta/html/odc_ipinfopathdecisiontree.asp?frame=true

http://msdn.microsoft.com/office/understanding/infopath/default.aspx