<?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: Web Service Query Error Through Infopath</title><link>https://www.infopathdev.com:443/forums/thread/23447.aspx</link><pubDate>Thu, 04 Oct 2007 13:58:29 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:23447</guid><dc:creator>adamrharding</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/23447.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=23447</wfw:commentRss><description>&lt;p&gt;Hi&lt;/p&gt;
&lt;p&gt;Are you querying the data via the web service or via the database as this could be the difference.&amp;nbsp; From what I understand, the dataset diffgram is used to track changes between the old data and the new data.&amp;nbsp; What I believe the error is saying is that within the diffgram there is a set of data which doesn&amp;#39;t match on name the dataset in the schema (form).&lt;/p&gt;
&lt;p&gt;On this understanding, maybe the web service GetData is different from the web service SubmitData hence when getting the results from the query you are almost attempting to fit a square peg in a round hole.&lt;/p&gt;
&lt;p&gt;So, in summary, I think this is down to the &amp;quot;shape&amp;quot; and &amp;quot;name&amp;quot; of the data is diffierent in one case from the other.&amp;nbsp; Look into this and you will find the source of this error.&lt;/p&gt;
&lt;p&gt;Sorry I cannot be more specific but on my rudimentary understanding this is what it sounds like.&lt;/p&gt;
&lt;p&gt;Cheers&lt;/p&gt;
&lt;p&gt;Adam&lt;/p&gt;</description></item><item><title>Web Service Query Error Through Infopath</title><link>https://www.infopathdev.com:443/forums/thread/23407.aspx</link><pubDate>Wed, 03 Oct 2007 08:59:32 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:23407</guid><dc:creator>alex350r</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/23407.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=23407</wfw:commentRss><description>&lt;p&gt;Hi all,&lt;/p&gt;
&lt;p&gt;&amp;nbsp;I have a webservice setup in Visual Studio, when i use the wizard in Infopath to set up the form i can successfully use the webservice to insert data into the sql server.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;However i cannot select &amp;#39;recieve data&amp;#39;, i get the following error:&lt;/p&gt;
&lt;p&gt;&amp;quot;The data contained a dataset diffgram which has a dataset with a different name than the associated schema indicates&amp;quot;&lt;/p&gt;
&lt;p&gt;Does anyone have any ideas as im not sure what this error means?&lt;/p&gt;
&lt;p&gt;&amp;nbsp;Thanks,&lt;/p&gt;
&lt;p&gt;Alex&lt;/p&gt;</description></item></channel></rss>