Re: Issue in fetching The Data from SQL to infopath Form.

ErnestoM — Thu, 24 Feb 2011 12:33:46 GMT

Yes, a large data set from SQL will not perform well in InfoPath. The solution is to filter the data on the server. To accomplish this, you can use a 3rd party tool like DBXL to filter the data before it reaches your form. DBXL includes a web service called QueryDB which can do this.

The other option is to write your own web service in order to filter the data. Good luck!

Issue in fetching The Data from SQL to infopath Form.

sanjay619 — Thu, 24 Feb 2011 04:55:27 GMT

hi.

i am having infopath form i am fetching data from SQl to Sharepoint list(External List) for this i have used External list.

the problem is that my sql table which has less data easily populate in External list if i try to fetch large data it shows error.

so i have triyed to fetch data directly from sql to infopath form but it takes almost 3 min to populat data in infopath form from SQL.

Thanks in Advance If 1 Can help!!!!!!!!

General

Re: Issue in fetching The Data from SQL to infopath Form.

Issue in fetching The Data from SQL to infopath Form.