Web Services

Re: Webservice no submitting correctly

B.Shiva Prasad — Tue, 03 Apr 2007 07:11:33 GMT

Hi chowyunli,

You told that while submitting each individual record it showing correctly but at submission of bulk of record 1 record is less. Means its not the DB or any thing fault check once the condition that how many times the loop is repeating. i hope you mentioned like this

(index = 1; index < 10; index++)

this will turn only 9 times, for 10 times the condition will be index <= 10.

Hope this will help you. If it is not please let me know.

Re: Webservice no submitting correctly

chang — Tue, 03 Apr 2007 07:09:43 GMT

Have you already looked in the Windows event and IIS logs to see if any errors have shown up there?

Webservice no submitting correctly

chowyunli — Mon, 02 Apr 2007 21:11:53 GMT

Hello All,

I have an InfoPath form that submits data to a .NET webservice. The webservice parses the infopath form and inserts the data into a database. The database is SQL Server EXPRESS.

I have however run into some problems. The InfoPath form is within SharePoint and I noticed that when I submit the data, it only shows up in the database as a new record 9 out of 10 times. That is for every 10 submissions of the form, there are only about 9 new records in the database. The ID field (an autoincrement field) also skips a number indicating the the transaction may have failed.

However, when I test the form on my local PC, it inserts a new record for every submission.

The webservice and database are on a remote server not my local.

Does anyone have any ideas? Could it have something to do with the webservice (latency?) or could it be a deficiency of SQL Server Express?

Any ideas, answers or suggestions would be much appreciated.