Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / January 2008

Tip: Looking for answers? Try searching our database.

Infopath2007: Submitting to SQL database via Webservice

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Harold P. - 25 Jan 2008 17:56 GMT
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/archive/2007/01/29/submitting-to-a-database-via-w
eb-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 - 25 Jan 2008 20:43 GMT
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.
Signature

Thanks

Clay Fox / InfoPath MVP

> 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
[quoted text clipped - 15 lines]
> article.   I am new to visual C#, so please let me know if more info is
> needed.  Thanks.
Harold P. - 25 Jan 2008 21:52 GMT
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?

> Hi Harold.
>
[quoted text clipped - 25 lines]
> > article.   I am new to visual C#, so please let me know if more info is
> > needed.  Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.