Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


An Introduction to InforPath 2003


An Introduction to InforPath 2003

Author
Message
Dinesh Asanka
Dinesh Asanka
SSC Eights!
SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)

Group: General Forum Members
Points: 966 Visits: 223
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/da






My Blog: http://dineshasanka.spaces.live.com/
Dinesh Asanka
Dinesh Asanka
SSC Eights!
SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)

Group: General Forum Members
Points: 966 Visits: 223

I am waiting for some comments to prepair the second artilce of the series

Waiting








My Blog: http://dineshasanka.spaces.live.com/
Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1989 Visits: 235

Great overview. I'm curious, must each user have Infopath to even fill out the form? If so, that would be a serious limitation.

It sounds like a great workflow type solution.



Brian Knight
Free SQL Server Training Webinars
spring42
spring42
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 5

Hello Dinesh,

I just e-mailed you directly before I saw this newgroup. Being new to SQL and Infopath, and having an access workflow application that I would like to move to SQL, I am very interested in how to go about setting up an infopath form that collects data for a sql database. I have found it difficult to find this information on MS's site or in the online help. I am eagerly awaiting your next installment.

Thanks,

Julian I. Spring




I went ahead and signed the screen but how do I get the ink off the monitor???
Robert Butler
Robert Butler
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 1
I think this overview was atrocious. It contained very little useful information and was full of poor English. If you are going to write articles in the English language, get a proof reader! And if you want to capture your reader's attention, make your articles more interesting.
Anthony Willms
Anthony Willms
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 24
First, I am in agreement with Robert regarding the readability of this article. I would highly recommend running your next article by a proofer prior to posting.

Second, I don’t think that MS has ever (or ever will) refer to InfoPath as Access’s ‘counterpart’ – at least not in the sense of a replacement of Access. If you are using that word in the sense that it is a ‘compliment’ to Access, then I can buy that. See the article here (http://office.microsoft.com/en-us/assistance/HA011032471033.aspx) for a comparison of the two, and information regarding how to use Access as a data store for InfoPath.

With that said, I am intrigued by your suggestion that SQL Server can be used as a data store for InfoPath. Your article has prompted me to do a little more research into this area.
Dinesh Asanka
Dinesh Asanka
SSC Eights!
SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)SSC Eights! (966 reputation)

Group: General Forum Members
Points: 966 Visits: 223

I accept that my English not good and I am trying my level best to improve this.

Secondly, Yes Infopath is using access or SQL Server and the storage device. Apart from the storing there are many more things can be done in InfoPath 2003. but as this is SQL Server dedicated web site I had my focus only on storage.








My Blog: http://dineshasanka.spaces.live.com/
Anthony Willms
Anthony Willms
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 24
Thanks for your reply to my post. Your quote from Oscar Wilde is well received. However, I am disinclined to believe that Oscar Wilde never hurt anyone’s feelings unintentionally – unless, of course, he never talked to anyone else. Even then, the most diplomatic of us can’t avoid hurting another person’s feelings.

My intent was not to criticise your grasp of the English language, but to recommend that you make use of a proofer prior to publishing an article. Even those of us whose first language is English must do the same. I am weary of reading articles where it is clear that the author is the only one who proofed the article prior to publishing. Before I put anything in print, I have made it a practice to have someone else look it over to see if it makes sense and there are no grammatical issues.

I understand the fact that you were writing this article for a SQL Server publication, which therefore, prompted you to focus primarily upon storing data in SQL Server. My comments regarding Access had to do with the following comments in your article:

“Another drawback is unavailability of reports like in Access. This is because main aim of InfoPath is to collect data and store them.
But I think Microsoft will develop these solutions in future release to keep and grow the users of of InfoPath.”
And
“InfoPath, the new member of the Office family has many advantages over its counter part, Access. Even though it is not popular as such, slowly it is catching up.”

Your qualifier that a primary aim of InfoPath is to collect data and provide [minimal] storage of such data is accurate. I simply don’t believe that MS has any intention of InfoPath ‘catching up’ (to use your words) with Access in the sense that it will ever replace Access as a database tool. That was my entire point.
Richard Moldwin
Richard Moldwin
SSC-Enthusiastic
SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)

Group: General Forum Members
Points: 132 Visits: 15

First of all, I think the English was good enough for a web publication, and the article was perfectly understandable despite a few grammatical errors. I don't think it's fair to pick on such trivial issues.

Second, I think InfoPath fills a very different role than Access. Access is a much more capable environment, and is much more powerful than InfoPath.

The main advantage of InfoPath over Access seems to be its ability to be used in a disconnected non-interactive environment, where batch Insert-only data submission is used. Data Access Pages were supposed to address this somewhat, but unfortuntely suffered from some rather severe limitations. I don't really understand why anyone would want to use InfoPath in a connected environment, when better (non-XML-based) tools are available (e.g. Access, .NET.)

From my limited knowledge of InfoPath, it seems to be not at all suitable for the majority of traditional database applications where information workers need to see the existing data (and related data), and to make entries based upon data that already exists. For my purposes, I can't really see a use for it. But for those people who require Insert-only interaction, I can see where it might be a reasonable option.


PETER NEWMAN
PETER NEWMAN
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 1
While I agree with some of your comments, I don't think InfoPath was ever intended to be a DB. From my limited knowledge it seems to be a data input and reporting tool that permits the user, to extract and present information from the DB, without programming or macro writing.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search