SP Designer 2007 / Data Source Library / site linked but doesn't display lists.
I have two sites, and full privileges on both. I'm using SP 2007 and Designer 2007. On a page in the first site, in Designer, I added the second site to the data source library so that I can get data from one of its lists. I added it by 'connect to another library / add / browse / ok' The site shows up in the data source library but the lists on the site are not there. The only options under the site name are Database connections, xml files, server-side scripts, and xml web services. There's not an entry for lists at all. The site has two lists. This same technique has worked for obtaining data from other sites' lists, and I don't see anything special about this site, but neither of its lists show up in the data source library. Thanks for any suggestions! Tracy
November 15th, 2011 9:01am
hi, this is the default behavior and in MOSS 2007 if you want to connect a list from another site collection you have to use coding. you can only connect the list from site which is in a same site collection. for coding please refer - http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/cf866358-3279-4140-a4e2-b99666efa5aaWarm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights
May 17th, 2012 5:33am
Hi, You can only do this within the same site collection. If you want to do the same then I would suggest you to export the other site collection and import into your first site collection. I hope this will help you out.Thanks, Rahul Rashu
May 18th, 2012 4:24am