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