Infopath2007: Submitting to SQL database via Webservice

[Harold P.]

I have been trying to develop a browser-based infopath2007 form that submits
to our SQL database. I understand that a browser-based form cannot submit to
a database directly, but can do so via a webservice. I am attempting to set
this up by referencing the following page:
http://blogs.msdn.com/infopath/arch...-web-services-in-infopath-forms-services.aspx
(which gives step by step instructions), and have been successfull in setting
up everything descirbed in the article. However, once I attempt to create a
form based on a web service I get an error while going through the wizard.
The error states:

The SOAP response indicates that an error occurred:

Server was unable to read request. ---> There is an error in XML document
(1, 406). ---> Input string was not in a correct format.


I only modified the code where it states to do so. The part of the code I
modified are for the database connections and webmethods as described in the
article. I am new to visual C#, so please let me know if more info is
needed. Thanks.

 

[Clay Fox]

Hi Harold.

There are examples of using web services on http://www.infopathdev.com in
the download sections. How to setup, etc. The Database Accelerator is a
package of prebuilt web services for interacting with SQL so the examples
might be relevant.

One thing are you using a UDC? You must setup a UDC for browser based forms
so that IFS knows how to handle them.

 

[Harold P.]

Thanks for you reply, Clay. Can you refer me to a good site with info on how
to create a UDC file for my web service proxy?