InfoPath Dev

 After seeing mention of it on the blog post you provided, I half heartly tried it last Thursday to no avail. But it was late in the day and I was ready to get out for a three day weekend.  Fast forward to today, I tinkered around a little more and it looks like I finally got it working! Below is the updated Store Proc that I finally ...

Correct, when calling the proc from the code above the data is not written to the table, bit it does trigger the identity trigger to increment. When I call the proc from a SQL editor, the data is written and the identity increments just like it should, using the exact same command. InfoPath 2010, don't think it is SP'd yet.

 Interesting read, but not exactly what I am looking for (I think). The form it self has no bearing on what ID number is used or if used at all. I am looking for the form to insert two fields into the table, and let the table's Identity feature make the unique key for the row. An application using the data inserted later will care about ...

 Venturing into the realm of InfoPath to create a form which will be published to a SharePoint site. I have gone through a lot of learning of creating the form, using secondary connections and filtering its data, and just trying to be able to find a way for the form to dump the information into a SQL table. Probing around I found a solution ...