InfoPath Dev

I have an InfoPath form (2007) that currently submits to a SharePoint (MOSS or 2010) Form Library (promotes the form fields to SharePoint columns). I was looking to create an additional data connection that would be used when the form status is complete. For this data connection, I am looking to load all of the form data into a Access or SQL database. I'm having a difficult time - does anyone know how this is done?

Submitting to SQL is a classic InfoPath problem. Here's what was discussed in an earlier thread:

Thank you for your help! I have a couple follow up questions about DBXL-

1. What happens when the form is deleted in SharePoint? In addition to our reporting needs, we are looking to move data off of the content databases and solely store them in SQL
2. Does the software work for mySQL, Access DB, etc?
3. Who can set up the mapping? What permissions are required within SharePoint and within the database?

Hi,

I'll try to answer your questions.

1. There's no one unique way to integrate DBXL with Sharepoint. There are a few options, depending on whether you want users to be able to delete, for example. This document is a good start, but there are more options that we are in the process of documenting.

2. No. Only SQL and SQL Express.

3. In the software's web.config you can define administrators who can set up mapping. You can also define Readers and Writers.

Feel free to email sales at qdabra dot com for more info, a demo or anything else. Thanks!