Anyone here have any experience with InfoPath? Have a project that I'll need to do an estimate and possibly design for and we're thinking that InfoPath would be what we want to use for it. In short, it's going to be a data collection form, where the user will fill in some information, attach external supporting documentation, and then submit it. We want (we think) to store everything in a SQL Database (I'm thinking maybe Sharepoint, which we already have setup) and then a report can be run against that data.

What I'm looking for is stories (good and pad), pitfalls, or gotchas that people have experienced with using InfoPath. One of the things we're concerned about is the security of the database connection string. Is it something that can be configured on the fly on the server - production passwords change on a regular basis. Things like that.

-tg