Data connection - Submit to SQL Zoltan Fedor 29.09.2006 13:03:01 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, -- Zoltan Fedor

Re: Data connection - Submit to SQL "Madhur" <ashu-wipro[ at ]nospam.nospam> 29.09.2006 18:52:41 Zoltan Fedor wrote: [Quoted Text] > 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 -- Madhur Ahuja http://madhurahuja.blogspot.com