InfoPath Dev

Hi, I am now able to insert and update sql table using web service. I just have a question. After I submit the InfoPath form, it sends the form to SQL Database table and SharePoint Library. So, when I open the submitted form, I managed to display the update button(it uses Update web service), but I cannot get the specific row to update. I ...

Hi, I Attached the code that I wrote for inserting. I don't get any error for Update. I tried to do something similar to the code in the link below under "Update Records Using Command Objects". http://msdn.microsoft.com/en-us/library/ms233819(v=vs.80).aspx I don't get error, it just does not update the table. ...

Can anyone help me pls?

Let me correct myself with the error above; I only get this error within SharePoint. It works fine with InfoPath Client. Yes, I wrote custom web service for inserting data. Yes, I can modify it, I'm not sure how to update the table. I mean here is my current lines for inserting data; (Actually there are more than three fields, but I only ...

Hilary, Thanks for your reply. I attached the error. If you need, I can copy the whole text to here, but I think it will look ugly. My main concern is updating the sql table using InfoPath Form. I still can manage to submit data with my web service, but I'm not sure how to do when I want to update the data. Thanks

Could anyone tell me how to call stored procedure for updating table in SQL from InfoPath 2010? Are there any article that I can follow? Thanks

Hello, I created web service submitting data to SQL table, I did not use stored procedures. It was for one project Now, I think it is time to use stored procedures, I need to send data to sql table, and update the data in sql table when the InfoPath opens for reviewing. I'm not sure how to call stored procedure for updating ...

Hi Jo-Anne, It is in a different server machine. The user account has db reader and writer access to SQL. It might be a problem in SQL endpoint. I found some articles referred that it can be authentication issue, but I could not find any documented solution yet. Thank You

I created the infopath form and the webservice. I have access to the webservice. I get this error when I hit submit, it is a basic form with two fields, and I want to send it to sql database with webservice. It works with InfoPath, but not on browser. Yes, I have data connection, otherwise I can't submit it to db. I got this error from the uls ...

Hello, I created the InfoPath form to submit data. I did troubleshooting and I have the error below; There was an error in the incoming SOAP request packet: Client, LoginFailure, AccessDenied SOAP-1_2-ENV:Sendersqlsoapfaultcode:LoginFailuresqlsoapfaultcode:AccessDeniedThere was an error in the incoming SOAP request packet: Sender, ...