Hi markperry,
did you already find a solution ?? I have the same problem. Trying to insert data to sql over a webservice. The query works but when submitting, no data arrives in sql, although InfoPath confirms a successful submit.
By the way, when trying the same with an access database doesn't work either.
Would be great if you can help ...