Data connection - Submit to SQL

[Zoltan Fedor]

Hello,
I have an infopath form with some data connection to SPS.
I would like to add an additional data connection to Submit some of the data
to an SQL database. I started the Data Connection Wizard, choosed Submit
data, but have only the following options:
- To a web service
- To a Sharepoint form library
- As an email message
So I have no choice to select an SQL database...
How can I add a new connection to SQL?

Thanks,

 

[Madhur]

Hello,
I have an infopath form with some data connection to SPS.
I would like to add an additional data connection to Submit some of
the data to an SQL database. I started the Data Connection Wizard,
choosed Submit data, but have only the following options:
- To a web service
- To a Sharepoint form library
- As an email message
So I have no choice to select an SQL database...
How can I add a new connection to SQL?

Thanks,

Hi

There are some limitations. You can only submit to the database only if you
choose the database template initially.

I would recommed to submit to the database, use the webservice and write
code in webservice to submit to database.

See this blog :
http://madhurahuja.blogspot.com/2006/06/limitations-of-infopath-2007-ability
..html

 

[Zoltan Fedor]

Hi Madhur,
Thanks for your useful answer!
I am not happy about InfoPath... it should be a basic function in my mind...
Maybe I can write some VB script behind the form to connect to a database
and save some important data to it.
Thanks,
Zoltan