InfoPath Dev

I need to create an Infopath form, so that when the user clicks submit, it will be sent to a library and saved, then some of the data within it sent to SQL along with the URL of the form. I have worked out how to create a database form to submit directly to SQL and also a form to submit to a library, but I need to do both. I have looked online for help and found Qdabra. There are reasons for this odd request. We have legacy software that queries sql for data. We are moving to Sharepoint, but until we do there needs to be data in both places. I have created a mapped form, but when I click submit I get an Invalid field name. {00000000-0000-0000-0000-000000000000} /Lists/My List

Hi,

Thanks for finding Qdabra!

qRules won't be the solution for you but DBXL might be. We have a free trial of DBXL available on Qdabra.com and we have free DBXL training modules and videos available here:

http://www.infopathdev.com/files/folders/dbxl/default.aspx

DBXL will allow you to submit your form's data to SQL and a SharePoint form library. If your legacy software is only querying SQL for data (not writing) then DBXL should be an appropriate solution. The free trial will give you the chance to try out the product and decide whether it will address your requirements.

If you'd prefer 1-on-1 assistance to get your scenario up and running quickly, Qdabra offers Consulting services and Support. Let us know how we can help. Thanks!

Unfortunately the cost of DBXL eliminates using it. I will look for another solution. Thanks.