InfoPath Dev

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.

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

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.