Hi, is it just me (probably is) or is SharePoint a pain in the...??? Life is already so complicated, can't Microsoft come out with something that works and is easy to use? Sorry, just frustrated so hope you can help!
I'm just trying to create a simple connection to a table in SQL and it all goes seemingly perfectly in SharePoint Designer and I create the operations just fine, first when I tried to view the list it came back with access denied and I found an article saying you need to assign permissions in central administration for BDC. Done that now I get the following incredibly helpful error message when I try and view the list, aaarrrgh!!!!!!!!!!!!!!!!!!!!
"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.
SWEAR WORDS HERE!!!!
Any guidance appreciated thanks