We have an infopath form that, when opened, pulls some data from a remote MS SQL server to populate a drop down box. After selecting an item from the dropdown box, it populates other elements in the form. Then we can edit those elements and set new properties on some of the additional elements.
After this is done we click the submit button, which we have tried to set up to use a c#.net web service (that we made) to insert that data into a different database on the same remote server. When doing this, it has an alert pop up saying it submitted successfully, but when looking at the database table, it did not insert any data.
We used this tutorial to create the web service and set up the form:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_ta/html/OfficeInfoPathWebServiceASPNET.aspWe did not, however, do Section 3 of that tutorial because it did not look like it was needed for what we are doing.
So we think everything is working except for the web service.
Any help would be greatly appreciated!