https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/105776.aspxThu, 10 Mar 2016 15:39:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105776Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105776.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=105776InfoPath can connect to SOAP or REST. :)https://www.infopathdev.com:443/forums/thread/105774.aspxThu, 10 Mar 2016 14:59:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105774Harman26850https://www.infopathdev.com:443/forums/thread/105774.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=105774Thanks Hilary!! i will create a web service for the same. just one question, can i use webapi as dataconnection or i need to create soap web service only.https://www.infopathdev.com:443/forums/thread/105731.aspxTue, 08 Mar 2016 19:56:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105731Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105731.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=105731By default, InfoPath is returning all the records. The only way to change the query InfoPath is sending to SQL is via code (or a product my company makes called qRules - it can do this too). Are you able to add code to the form? Oh, another option would be to use a web service to query your SQL DB - again, we have a product for that or you can write your own. Here's a post that has some code for querying: http://www.infopathdev.com/forums/t/23018.aspxhttps://www.infopathdev.com:443/forums/thread/105725.aspxTue, 08 Mar 2016 16:53:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105725Harman26850https://www.infopathdev.com:443/forums/thread/105725.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=105725Hi All, I am working on a requirement where user needs to enter first name , last name and all matching records will be pulled from database and displayed . I have created a SQL Server dataconnection and used repeating section to display the data. But when i click on button, i get timeout error. Is it that as database has 8 million records, initially it will pull all the records? Can we filter the data to be pulled from database? If not, what is the best approach to implement this requirement. vl really appreciate if anyone can help me with this Thanks Harman