<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SQL Database Integration</title><link>https://www.infopathdev.com:443/forums/47.aspx</link><description>For questions concerning issues in the integration of SQL and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: InfoPath Error Executing a Stored Procedure</title><link>https://www.infopathdev.com:443/forums/thread/17379.aspx</link><pubDate>Wed, 23 Aug 2006 07:30:01 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:17379</guid><dc:creator>Patrick Halstead</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/17379.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=17379</wfw:commentRss><description>Hi Sam1996 (are you really 10 years old?) and welcome to our forum!&lt;br /&gt;Sounds like you are using a query adapter for your main data source. You might consider querying the sproc into a separate secondary data source and then mapping that into your main data source, but that's a ton of work. &lt;br /&gt;&lt;br /&gt;The main data source no doubt has a schema issue with the query results. You'll want to look at the XML returned and see what values are not in compliance with the XML schema. Maybe there's a node that's not repeating that is getting extra XML. Not sure, but this is why the Database Accelerator is a good tool for you - it simplifies the whole process of interacting with the DB by segregating the schemas - forms are roundtripped as XML and shredded out as SQL data for reporting. The SQL relational data is not used to rehydrate XML.</description></item><item><title>InfoPath Error Executing a Stored Procedure</title><link>https://www.infopathdev.com:443/forums/thread/16845.aspx</link><pubDate>Thu, 17 Aug 2006 18:06:00 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:16845</guid><dc:creator>sam1996</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/16845.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=16845</wfw:commentRss><description>Hi All,</description></item></channel></rss>