IIS + SQL*Server + InfoPath Integration Guidelines Please

[martin carmichael]

Hello,
I am very new to infoPath.

My goal is to develop a front-end web page hosted on IIS.
This page would allow visitors to fill the form and post (submit) and
save their comments inside a SQL*server table.

How easy is it to do this ?
Where do I start ?
Is there samples available somewhere ?

Of course, I do not want visitors of web site to have infoPath
installed on their desktop. Just go on the web site and fill the
form.

help, suggestions and comments are welcome
thank you

 

[MatsonPP]

Good day Martin!

Since InfoPath is a thick client, a form designed in InfoPath will have
to be run in InfoPath. Sorry to say, but this is how it is. Users
travelling to your page to fill out this form would be required to have
InfoPath installed.

As for writing to an SQL Table, this is insanely easy with InfoPath's
User Interface. When you go to create a new form (using the task pane)
select "New from data connection". This will now bring you to a wizard
that will allow you to connect to an SQL data base or Microsoft Access
database.

I hope this helps!
Matt

 

[kfrost]

Martin,

If you want to build an Infopath form and then build a web page similiar to
the form I recall seeing a couple of docs on this. Probably just do some
searching on Infopath and web pages.

Also, you are looking for reference material, there are a couple of books
out there decent about learning the basics of Infopath, Beginning Infopath
2003, Programming MS Infopath A developers Guide and then there's
Professional Infopath 2003. My sitation is I'm trying to learn how to use
VS.Net to build my forms and I've yet to find an advanced book with real
world examples.

I've also been going through the MSXML 5.0 chm file that is office
installation directory.

Finally somebody suggested I order the Fabrikam 3.1 learning center which
takes a fictitious company and builds real world solutions. I just got it
and it looks promising. It comes with a VPC image with examples of how
implement solutions using Infopath as well as other office products. You can
find it by searching for fabrikam 3.1 on the ms website.