Submit to a Database - Option missing?

[ElScrimmo]

I have an InfoPath2003 form which has a SQL Server 2005 Data Source. All
controls have nice Green binding status, but when I try to set the Submit
Options, I only have Web Service, script or HTTP. I was expecting to see
Database.

Is something missing, or do I have steps that I have missed?

Thanks

Richard

 

[benoitc]

I'm pretty sure you're only allowed one "submit" action per form, even
if you have more than one button. If you set them both as
action=submit, they will both be set to the most recent data
connection you've defined as submit. This is why when you checked
your form again, they were both attached to "Main Submit 2", since
that was the last one that was specified.

What you can do is have the button action be "rules and custom code",
and then use the data connection from script, like this:

XDocument.DataObjects["MyDataConnection"].Query();