Im test installing Database Accelerator for shredding data into Sql. I have already designed a custom form that query other webservice as well as containing custom codes. I cannot get this form to work with the qdabra software. I have successfully get the included expense report to work just fine both using the local host database as well as using a remote database. The sample expense report saves as well as insert data correctly.
Why trying to use my form to submit data:
1. Initially the form when submitted will say it was successful but no new documents appear under the "Documents" tab in Qdabra NOR any sql entries.
However I changed a number of things, one being setting Security Level to "Automatically determine security level" instead of having the "Sign this form template". I also removed any custom codes. So I am not sure what works but it moved along to scenario two below.
2. The form will say submitted successfully; documents appears under the "Documents" tab in qdabra. However, no sql data entries appear.
So this is the puzzler?????
When I do a submit using the expense report I can see that it's attempting to make a web service connection and see any sql errors. However, my form just immediately shows the successful dialog....no attempting to connect to the webservice or sql errors. It leads me to think it's some settings in my form is causing the trouble, but not sure what?
My setup:
Infopath 2010
Two different Dev sharepoint server.
One server has Qdabra install, while I am using another for Qdabra to save to the sql server