<?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: problem in data retrieval from database</title><link>https://www.infopathdev.com:443/forums/thread/17371.aspx</link><pubDate>Thu, 31 Aug 2006 19:56:00 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:17371</guid><dc:creator>Matt Faus</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/17371.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=17371</wfw:commentRss><description>This seems weird.  Maybe you should delete the data connection and re-add it so that the corruption doesn't happen again?  If all else fails you can extract the form files and manually edit the schema file for the 2DS.  If you need help doing this, reply back.</description></item><item><title>problem in data retrieval from database</title><link>https://www.infopathdev.com:443/forums/thread/16841.aspx</link><pubDate>Mon, 07 Aug 2006 09:16:46 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:16841</guid><dc:creator>adawood</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/16841.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=16841</wfw:commentRss><description>I am new to infopath and submitted this question but could not get any response. I will appreciate if anyone can help me with this problem.&lt;br /&gt;I have created an infopath form based on a data source and searching for an item. when I run the script, it gives message " The conversion of the nvarchar value '021111000000" overflowed an int item maximum integer value exceeded"&lt;br /&gt;When I place the field itemcode on form it takes the data type of simple automatically and does not allow me to change. The data field in database is defined as nvarchar. Any help will be highly appreciated</description></item></channel></rss>