Microsoft KB Archive/867434

= BUG: Server data is not updated as you expect when you submit an InfoPath form =

Article ID: 867434

Article Last Modified on 4/19/2007

-

APPLIES TO


 * Microsoft Office InfoPath 2007
 * Microsoft Office InfoPath 2003, Service Pack 1 (SP1)

-





SYMPTOMS
You can design a form in Microsoft Office InfoPath 2007 or in Microsoft Office InfoPath 2003 that submits the data of the form to a Web service method. The Web service method has the System.Data.DataSet object as a parameter. When you fill out the form and then click Submit, the ADO.NET DataSet on the server is not updated as you expect.

This problem occurs although you receive a message that the form is submitted successfully.



CAUSE
This problem occurs if all the following conditions are true:
 * The InfoPath form is created from a Web service.
 * The InfoPath form is configured to only submit data to the Web service.
 * The Web service method uses the System.Data.DataSet object as a parameter.



WORKAROUND
To work around this problem, configure the form data connection to send data and to receive data when you design the form. To do this, follow these steps:
 * 1) Start InfoPath.
 * 2) In the Data Connection Wizard, click Web service, and then click Next.
 * 3) Click Receive and submit data, and then click Next.
 * 4) Click a Web service with a method that returns a DataSet with the same schema as the DataSet that you want to submit, and then click Next.
 * 5) Click the Web service that you want to receive the data from, and then click Next.

Note You do not have to actually receive data from the Web service. This option changes the way that InfoPath serializes data. This is described in the &quot;More Information&quot; section.
 * 1) Click the Web service that you want to submit the data to, and then click Next.
 * 2) Click the Web service method that you want to submit data to, and then click Next.
 * 3) Map the parameters of the Web service method to the fields that InfoPath automatically generates from the Receive Web service method.
 * 4) Click Next. Click Finish.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
When a form is configured to only submit data to a Web service, the data is serialized as XML. Because the data is not serialized as an ADO.NET DataSet, the data is not updated as you expect.

Steps to reproduce the problem

 * 1) Start InfoPath 2003 Service Pack 1.
 * 2) On the Fill Out a Form screen, click File, click Fill Out a Form, and then click Design a Form.
 * 3) Under Design a new form, click New from Data Connection.
 * 4) Click Web service, and then click Next.
 * 5) Click Submit data, and then click Next.
 * 6) Click a Web service with a method that takes a DataSet with the System.Data.DataSet object parameter, and then click Next.
 * 7) Click the Web service method that you want to submit the data to.
 * 8) Click Next. Click Finish.
 * 9) Open the form, fill out the required fields, and then submit the form.
 * 10) Verify that the data in the ADO.NET DataSet that resides on the server is not updated as you expect.

Additional query words: kbnoOfficeAlertID infopath2003 infopath2007 IP2007

Keywords: kbdev kbbug kbtshoot kbprb KB867434

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.