I'm taking my first crack at creating an External list in SharePoint 2010. I've taken 3 training classes in SharePoint 2010, and am now trying to transfer my knowledge to my own development environment. I've followed the steps for creating my External Content type in Microsoft SharePoint Designer. I am connecting the External Content Type to a table in an external SQL Server Database. I've created a list specifying this External Content type. I've also given all authenticated users permission. I've verified that BCS is running, and all looks good. I've also checked and double checked the steps I used in creating the external content type and list by referring to the lab manual from my Sharepoint class.
When I try to navigate to display the list, I get this very informative error message:
Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server, administrator.
I've tried opening this page in Sharepoint Designer but this doesn't seem to help me. Has anyone experienced this problem before? Any gotcha's that I should be looking for?
I've also turned on detailed logging to look for some more information. I've searched for the correlation ID reported in the Sharepoint logs, but haven't found any matches.