InfoPath Dev

Hi there,

I have a problem concerning Submitting to a SQL Database (via Web Services) in InfoPath web-enabled forms.
I already followed the instructions of the following TechArticle a few times with different pcs and servers and always hang at the end of section 2.

http://msdn2.microsoft.com/en-us/library/aa192516(office.11).aspx
 
I am using Sql 2005 VS2005 and Infopath 2007. I created a webservice
connecting to a database table of the Sql 2005 server. I created a web-
enabled form in InfoPath to submit and receive data to this webservice.
(exactly the way it is described in the microsoft article above)

If I try to use this form, I am able to query the database and it shows me content of the table. But I am not able to submit data to sql. If I hit submit, Infopath confirms the submission successful but sql doesn't get any data. It seems, that the sqldataadapter.update command does not really update the table.

When I create the same form with a database connection instead of a webservice connection, receiving AND submitting data works fine and sql table is updating or inserting new data.

What am I doing wrong ??
 
 
Bjoern

Hi bjoernscher,

I haven't read that MSDN article, because anytime I want to do this I just use the DBXL web service.  This web service can submit to back-end SQL databases easily and then the EnumDB web service can query from them again.

One tip on getting the other method to work is that I believe the Main DOM has to be based on the schema of the database.  If that is broken, then the submit fails.

Hi,

I had  a simlilar problem,which I was able to fix without using Qdabra. I created a main data connection to 'submit' to the database and then created a different connection (secondary) to  receive or query

the data.This solved the problem.

Cheers,

Swetha