SQL Database Integration

Re: Submitting to SQL database

Patrick Halstead — Tue, 03 Oct 2006 20:57:55 GMT

Hi Kurt and Michael and welcome to the forum,
Try creating the form "from the database". Then, submit should be available. InfoPath does not allow you to submit forms that are created using a separate XML schema (XSD). For that, you can use our DBXL Web service which adds a mapping layer between forms and DBs to make it easy for you to create and store forms in SQL without having to worry about keeping the XML schema and relational schema in perfect correspondence.

Re: Submitting to SQL database

micavid — Tue, 03 Oct 2006 19:50:28 GMT

I'm running into the same situation. I'm using infopath 2003 with sp2, SQL 2005. It worked for my other forms. But, this one specific form, it would not allow a submit button to database. I have recreated the form from scratch in many different ways and the results are the same, would not allow submit to database.

Any help appreciated. Thanks...Michael

Submitting to SQL database

neo0230 — Tue, 03 Oct 2006 15:18:58 GMT

I have Infopath SP2 and tried to create a submit to an SQL database.
When I navagate to the data connections and run through the wizard, selecting "submit data". In the next screen "How do you want to submit your data?" the database selection isn't present anymore.
Does anyone have any suggestion on to submit to a SQL database with InfoPath SP2?

Thanks...Kurt