Submitting to SQL database - InfoPath Dev
in

InfoPath Dev

Submitting to SQL database

Last post 10-03-2006 01:57 PM by Patrick Halstead. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-03-2006 08:18 AM

    • neo0230
    • Not Ranked
    • Joined on 10-03-2006
    • USA
    • Posts 1

    Submitting to SQL database

    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
  • 10-03-2006 12:50 PM In reply to

    • micavid
    • Not Ranked
    • Joined on 10-03-2006
    • USA
    • Posts 1

    Re: Submitting to SQL database

    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
  • 10-03-2006 01:57 PM In reply to

    Re: Submitting to SQL database

    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.
    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.