Form submitted successfully but doesnt show up in the database!

[swethabilla]

Hi,
I am facing a problem when i try submit an infopath form. I get the
message "form submitted successfully" but doesnt make the changes in
the database to which it has a main data connection.

If anyone could come up with a solution it would be great.

Thanks.

 

[Kalyan G Reddy MVP (GGK Tech)]

How did you build the form and do you have the action on the button to submit
it to the database?

 

[swethabilla]

Let me be more clear to you. I have created a simple database in SQL
server with only one table, with fields ID and Customer name.

I created a webservice with two methods to get customer info and to update it.
next I created an infopath form with the main data connection to the webservice . I inserted the fields ID and Customername in the form.
I also inserted the submit button and configured it to submit to the webservice that I created.
When I hit the Query button It retrieves the records that I already inserted in the SQL database

However when I submit another record and hit Submit it pops a message
"Form submitted successfully "but doesnt show up in the database or in
the webservice .
I am using Windows Vista and SQL server 2005.
Please let me know where I am going wrong.

Thanks.

 

[swethabilla]

I was trying to create the form again and I noticed that previously I
created the form as" web-browser enabled form" but when I unchecked
the option and created the same form again...it submits the entries to
the web service and to the sql server as well.
Can you tell me how can fix the problem of submitting in web-browser
enabled forms.

Thanks.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Read the links below
http://sheetal-d.spaces.live.com/Blog/cns!237C3DEA7120098B!626.entry
http://blogs.msdn.com/infopath/arch...-web-services-in-infopath-forms-services.aspx