<?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: UDCX stored proc not working - sometimes</title><link>https://www.infopathdev.com:443/forums/thread/107380.aspx</link><pubDate>Fri, 15 Jul 2016 21:36:36 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107380</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107380.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=107380</wfw:commentRss><description>Can you use SQL Profiler to see if the query is running at all?</description></item><item><title>UDCX stored proc not working - sometimes</title><link>https://www.infopathdev.com:443/forums/thread/107361.aspx</link><pubDate>Wed, 13 Jul 2016 17:45:14 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107361</guid><dc:creator>brandtsmith</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107361.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=107361</wfw:commentRss><description>&lt;p&gt;&amp;nbsp;Been a while since I&amp;#39;ve posted here...but the issue I am having is using a SQL stored proc (as a secondary data source) that I created a UDCX file from and uploaded to SP ....on a new form it works as expected...but if I have retrieved a record via a query, the UDCX secondary data source does not return any rows...the sql statement is correct...just no data...when I deleted the UDCX data source and re-created it to be an internal data source it works as expected in all scenarios...so for kicks I added the udcx data source back in and again - no rows after I queried a record....took it back out and re-created the data source internally again and all is fine.&lt;/p&gt;&lt;p&gt;????&amp;nbsp;&lt;/p&gt;</description></item></channel></rss>