Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / January 2007

Tip: Looking for answers? Try searching our database.

Update infopath form in SQL 2005

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
esebastian@esolutionsgroup.ca - 22 Jan 2007 16:58 GMT
Hello All,
I have a windows form built in c# that opens an infopath form and then
saves the xml to the database. THere is also an option to load the form
from the database and this work however if i load a form and then try
to save it back to the database i get an error saying the xml is
missing a ">" tag. If i output the xml it looks like it's well formed
so I have no idea what's going on.. anyone have a clue?
Thanks,
Erin
esebastian@esolutionsgroup.ca - 24 Jan 2007 21:03 GMT
There is a special way of saving and loading an infoPath form into Sql
. S.Y.M Wong A Ton has published a couple of great articles about it
that really helped me out. The thing is that you have to preserve the
encoding on the xml document that infopath gives to you and i wasn't
doing that.
Thanks,
Erin

1) how to retrieve infopath form from SQL
http://enterprise-solutions.swits.net/infopath2007/article.php?t=how-to-retrieve
-infopath-form-sql-server-display-formcontrol&c=infopath2007


2) how to insert infopath form into SQl
http://aspalliance.com/1106_Saving_InfoPath_Forms_to_SQL_Server_2005_as_XML#Page5
S.Y.M. Wong-A-Ton - 25 Jan 2007 05:31 GMT
I'm glad my articles helped you. Sorry I did not answer your posts. Since
I've never encountered the errors you got, it was difficult for me to say
what was really causing them.

And thank you for listing the solutions to your problems. I'm sure people
will benefit from them in the future.

Regarding your question: I do not know how you can go about saving the XSN.
The problem is that you have to publish the form before you save the XML to
SQL Server. And the path to the template is saved along with the XML, so the
XSN must physically exist somewhere. If you have SharePoint, you could look
into how SharePoint does it. SharePoint uses SQL Server to store its data,
including forms. I'm not sure, though where the XSNs are located. My guess
would be, also in the database. Perhaps that might give you some clues?

I'll keep mulling over it, and if I get a brilliant idea - I tend to get
those often :) - I'll let you know or write about it.
---
S.Y.M. Wong-A-Ton

> There is a special way of saving and loading an infoPath form into Sql
> .. S.Y.M Wong A Ton has published a couple of great articles about it
[quoted text clipped - 9 lines]
> 2) how to insert infopath form into SQl
> http://aspalliance.com/1106_Saving_InfoPath_Forms_to_SQL_Server_2005_as_XML#Page5
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.