SQL Database Integration

[RESOLVED]Submitting data to sql via webservices with infopath web-enabled forms

swetha — Wed, 25 Jun 2008 17:43:28 GMT

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

Re: Submitting data to sql via webservices with infopath web-enabled forms

Matt Faus — Thu, 14 Jun 2007 09:10:40 GMT

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.

Submitting data to sql via webservices with infopath web-enabled forms

bjoernscher — Wed, 06 Jun 2007 21:00:14 GMT

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