Hi, I have found this article about connecting to sharepoint List
http://www.connectionstrings.com/?carrier=sharepoint I have created this connection string Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=http://192.168.1.100:30000/Lists/Projects/;LIST={E25D5BB3-0CA2-4614-BDCE-A26A9C405B69};
But I am unabke to select from this list in asp.net page (just for test purpose). In future I want to connect this to sql report and generate reports from this lists. Has someone done something like this in past ? Or is it better way to generate reports from
sharepoint lists ?
supermajox
Member
1 Points
3 Posts
Connect to sharepoint-sharepoint reports
Aug 26, 2008 03:54 PM|LINK
Hi, I have found this article about connecting to sharepoint List http://www.connectionstrings.com/?carrier=sharepoint I have created this connection string Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=http://192.168.1.100:30000/Lists/Projects/;LIST={E25D5BB3-0CA2-4614-BDCE-A26A9C405B69}; But I am unabke to select from this list in asp.net page (just for test purpose). In future I want to connect this to sql report and generate reports from this lists. Has someone done something like this in past ? Or is it better way to generate reports from sharepoint lists ?