Passsing values to SQL database through Infopath using Internet

[Sarika]

Hi
I am new to Infopath and do not have much experience with Infopath
coding. I wanted to know whether it is possible to design a form in
Infopath which will submit values to a table in SQL server through the
Internet. For example, Suppose a sales person creates a sales quote at
location A(basically he fills an infopath form). I need this data from
the sales quote to be populated in the SQL server located in location
B. I want to use Sharepoint server to publish the infopath form on the
web.
Any help or suggestions in this regard would be great.
Thanks
SK

 

[Franck Dauché]

Hi SK,

There are really 2 questions in one here.
To the first one (SQL Server) the answer is yes. You can build a Web
Service around your SQL Server Db and you can add a Data Connection linked to
that Web Service in your IP form. Also, SQL Server (such as MS Access) is
native to InfoPath, so direct linking is possible. In your case, a Web
Service seems more appropriate.
To your second question (InfoPath on the Web), the answer is no. You will
need to have your users have local licenses of IP on their machine to be able
to open and modify data in the forms.
Note: if your users at location B just need to look at the data (read-only),
then you can turn XML generated with IP into HTML for display through the Web.

Hope that helps.

Franck Dauché