I have been using InfoPath for about a month now. I have a form that we are
using for Daily Maintenance. Once complete, it sends an e-mail and saves the
form to out Share Point server. Everything works great. I am also querying
a SQL database to populate some drop down lists. Recently, I decided that I
want to submit certain field in the InfoPath form to a SQL database.
My problem is that I cannot find anywhere in InfoPath that allows me to
submit data to a SQL server. Does this require me to write custom code /
scripts? When I go to create a data connection with the action of "Submit",
it only allows me to choose between a web server, share point, etc, but SQL
is not an available item.
Any help would be appreciated.