How to connect to data in a database

Formotus forms do not support ADO data connections directly to a SQL server or other database software because our forms communicate over HTTPS. In order to connect your  forms to your database you have two options:

1. Write and expose a SOAP/REST Web service to connect the form to the database. Here are some links to help you learn how to do that:

http://blogs.msdn.com/b/jannemattila/archive/2007/01/21/infopath-and-web-service-data-connection.aspx

http://msdn.microsoft.com/en-us/library/office/bb852081(v=office.12).aspx

http://msdn.microsoft.com/en-us/library/office/bb251004(v=office.12).aspx

http://blogs.msdn.com/b/infopath/archive/2007/01/29/submitting-to-a-database-via-web-services-in-infopath-forms-services.aspx

2. Use SharePoint as an intermediary. For example, use SharePoint's BCS to populate a list with data from the database, then build your form to query the SharePoint list. You can also submit Formotus form data to SharePoint lists.