SQL Database Integration

Re: infopath - sql

Clay Fox — Tue, 08 Apr 2008 14:32:01 GMT

If you are creating a database type form. You created it initially linked to a database then it will have some basic limitations that you will need to work around.

One of those limitations is the table must have a proper primary key and foreign key realtionships with any child tables or you will not be able to submit to it.

If you look at your main data connection it will list whether it can receive only or both receive and submit.

Once this is able to accept a submit just create a button and give it a rule and action to ssubmit the main data connection and it will push the information back to SQL.

If you want to have really unlimited interaction with your SQL data, query more than one table dynamically, submit to more than one table, then you need to use web services.

You can email me and I could show you how they can be setup and used.

Re: infopath - sql

qui84 — Tue, 08 Apr 2008 13:21:29 GMT

ok, i got it, the failure was in the db .... :)

Re: infopath - sql

Albert — Tue, 08 Apr 2008 11:59:24 GMT

Hi, can you be a bit more specific with i can't send the data to the sql ? What is exactly happening (or not) ?

Sometimes when you add a sqldataconnection it disables submit because of unsupported features. Try to recreate the dataconnection and check for messages (especially summary).

Albert

infopath - sql

qui84 — Tue, 08 Apr 2008 11:32:41 GMT

hi,

i've got a new problem :)
i've connected my infopath form with a sql-db, YES, i can receive the data from the sql db, but i can't send data to the sql.
when i connect it with a access-db, i give the button a rule to send data's to a databaseconnection, and it works perfectly ....

did i skip something? where is the failure?