https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/31408.aspxWed, 13 Aug 2008 06:04:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:31408Clay Fox0https://www.infopathdev.com:443/forums/thread/31408.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=31408<p>Large dbs are an issue.</p> <p>&nbsp;Ideally you can use a web service instead that can query the records instead of loading them all.</p> <p>You can maybe reduce the number of fields that are being loaded.</p>https://www.infopathdev.com:443/forums/thread/31181.aspxMon, 04 Aug 2008 18:04:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:31181StephanieG0https://www.infopathdev.com:443/forums/thread/31181.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=31181<p>I have a fairly complex InfoPath from that uses&nbsp;a large&nbsp;SQL database&nbsp;as a secondary connection (the database has several thousand rows). I added it to a SharePoint site with full-trust using Administrator-approval. The form works great when the user opens it in InfoPath, but when it is opened in the browser, we keep getting that pesky error: &quot;An error occurred accessing a data source.&quot; Looking at the server logs, the problem has to do with the Database Connection Response size. When I change the maximum response size under Configure InfoPath Forms Services in Central Administration and try to open the form, the computer runs way slow and warnings come up about the computer becoming unresponsive if the script isn&#39;t stopped. I&#39;m assuming all this has to do with the size of the database that the server is trying to load.</p> <p>Does anyone have any solutions or suggestions?</p> <p>Thanks =)</p>