Creating an External Content Type to SQL in SharePoint 2010

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.

Correlation ID:2faecc86-c04c-430e-9e5f-7ea26e64848c"

SWEAR WORDS HERE!!!!

Any guidance appreciated thanks
LVL 4
ebooyensAsked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
I remember using some colorful language when learning this.
Can you break down the problem... Just create an external list based on the operation for readlist/readitem. Can you view the list ok?
If so then we can move onto the webpart.
Is it a data view webpart?
The webpart wasn't deployed as a sandbox was it?
0
 
ebooyensAuthor Commented:
Thanks, yeah I've created a list based on the readlist (or is it readitem) operation and it's when I try to view this list that I get this error.  Have tried recreating it several times but I keep getting the same error no matter which table I use as a test.  So I've done all the work directly from within SharePoint Designer so no not a sandbox
0
 
ebooyensAuthor Commented:
Here's an export of the BDC if that's helpful?

<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<Model xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/windows/2007/BusinessDataCatalog BDCMetadata.xsd" Name="Consignees Test" xmlns="http://schemas.microsoft.com/windows/2007/BusinessDataCatalog">
  <AccessControlList>
    <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
      <Right BdcRight="Edit" />
      <Right BdcRight="Execute" />
      <Right BdcRight="SetPermissions" />
      <Right BdcRight="SelectableInClients" />
    </AccessControlEntry>
  </AccessControlList>
  <LobSystems>
    <LobSystem Type="Database" Name="NPHazWaste">
      <Properties>
        <Property Name="WildcardCharacter" Type="System.String">%</Property>
      </Properties>
      <AccessControlList>
        <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
          <Right BdcRight="Edit" />
          <Right BdcRight="Execute" />
          <Right BdcRight="SetPermissions" />
          <Right BdcRight="SelectableInClients" />
        </AccessControlEntry>
      </AccessControlList>
      <Proxy />
      <LobSystemInstances>
        <LobSystemInstance Name="NPHazWaste">
          <Properties>
            <Property Name="AuthenticationMode" Type="System.String">RdbCredentials</Property>
            <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>
            <Property Name="RdbConnection Data Source" Type="System.String">[ServerIP]</Property>
            <Property Name="RdbConnection Initial Catalog" Type="System.String">[DBName]</Property>
            <Property Name="RdbConnection Pooling" Type="System.String">True</Property>
            <Property Name="SsoProviderImplementation" Type="System.String">Microsoft.Office.SecureStoreService.Server.SecureStoreProvider, Microsoft.Office.SecureStoreService, Version=14.0.0.0, Culture=neutral, PublicKeyToken=[PublicKeyToken]</Property>
            <Property Name="SsoApplicationId" Type="System.String">sa</Property>
            <Property Name="ShowInSearchUI" Type="System.String"></Property>
          </Properties>
        </LobSystemInstance>
      </LobSystemInstances>
      <Entities>
        <Entity Namespace="http://sharepointurl" Version="1.2.0.0" EstimatedInstanceCount="10000" Name="Consignees" DefaultDisplayName="Consignees">
          <AccessControlList>
            <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
              <Right BdcRight="Edit" />
              <Right BdcRight="Execute" />
              <Right BdcRight="SetPermissions" />
              <Right BdcRight="SelectableInClients" />
            </AccessControlEntry>
          </AccessControlList>
          <Identifiers>
            <Identifier TypeName="System.Int32" Name="ConsigneeID" />
          </Identifiers>
          <Methods>
            <Method Name="Create" DefaultDisplayName="Consignees Create">
              <Properties>
                <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=[PublicKeyToken]">Text</Property>
                <Property Name="RdbCommandText" Type="System.String">INSERT INTO [dbo].[tableName]([Name] , [Address1] , [Address2] , [Address3] , [Address4] , [PostCode]) VALUES(@Name , @Address1 , @Address2 , @Address3 , @Address4 , @PostCode) SELECT [ConsigneeID] FROM [dbo].[tableName] WHERE [ConsigneeID] = SCOPE_IDENTITY()</Property>
                <Property Name="BackEndObjectType" Type="System.String">SqlServerTable</Property>
                <Property Name="BackEndObject" Type="System.String">tableName</Property>
                <Property Name="Schema" Type="System.String">dbo</Property>
              </Properties>
              <AccessControlList>
                <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                  <Right BdcRight="Edit" />
                  <Right BdcRight="Execute" />
                  <Right BdcRight="SetPermissions" />
                  <Right BdcRight="SelectableInClients" />
                </AccessControlEntry>
              </AccessControlList>
              <Parameters>
                <Parameter Direction="In" Name="@Name">
                  <TypeDescriptor TypeName="System.String" CreatorField="true" Name="Name">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">100</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@Address1">
                  <TypeDescriptor TypeName="System.String" CreatorField="true" Name="Address1">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">100</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@Address2">
                  <TypeDescriptor TypeName="System.String" CreatorField="true" Name="Address2">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">100</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@Address3">
                  <TypeDescriptor TypeName="System.String" CreatorField="true" Name="Address3">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">100</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@Address4">
                  <TypeDescriptor TypeName="System.String" CreatorField="true" Name="Address4">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">50</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@PostCode">
                  <TypeDescriptor TypeName="System.String" CreatorField="true" Name="PostCode">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">10</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="Return" Name="Create">
                  <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="Create">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="CreateElement">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.Int32" ReadOnly="true" IdentifierName="ConsigneeID" Name="ConsigneeID" />
                        </TypeDescriptors>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </Parameter>
              </Parameters>
              <MethodInstances>
                <MethodInstance Type="Creator" ReturnParameterName="Create" ReturnTypeDescriptorPath="Create[0]" Default="true" Name="Create" DefaultDisplayName="Consignees Create">
                  <AccessControlList>
                    <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                      <Right BdcRight="Edit" />
                      <Right BdcRight="Execute" />
                      <Right BdcRight="SetPermissions" />
                      <Right BdcRight="SelectableInClients" />
                    </AccessControlEntry>
                  </AccessControlList>
                </MethodInstance>
              </MethodInstances>
            </Method>
            <Method Name="Read Item" DefaultDisplayName="Consignees Read Item">
              <Properties>
                <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
                <Property Name="RdbCommandText" Type="System.String">SELECT [ConsigneeID] , [Name] , [Address1] , [Address2] , [Address3] , [Address4] , [PostCode] FROM [dbo].[tableName] WHERE [ConsigneeID] = @ConsigneeID</Property>
                <Property Name="BackEndObjectType" Type="System.String">SqlServerTable</Property>
                <Property Name="BackEndObject" Type="System.String">tableName</Property>
                <Property Name="Schema" Type="System.String">dbo</Property>
              </Properties>
              <AccessControlList>
                <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                  <Right BdcRight="Edit" />
                  <Right BdcRight="Execute" />
                  <Right BdcRight="SetPermissions" />
                  <Right BdcRight="SelectableInClients" />
                </AccessControlEntry>
              </AccessControlList>
              <Parameters>
                <Parameter Direction="In" Name="@ConsigneeID">
                  <TypeDescriptor TypeName="System.Int32" IdentifierName="ConsigneeID" Name="ConsigneeID" />
                </Parameter>
                <Parameter Direction="Return" Name="Read Item">
                  <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="Read Item">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Read ItemElement">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.Int32" ReadOnly="true" IdentifierName="ConsigneeID" Name="ConsigneeID" />
                          <TypeDescriptor TypeName="System.String" Name="Name">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">100</Property>
                              <Property Name="RequiredInForms" Type="System.Boolean">true</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="Address1">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">100</Property>
                              <Property Name="RequiredInForms" Type="System.Boolean">true</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="Address2">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">100</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="Address3">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">100</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="Address4">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">50</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="PostCode">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">10</Property>
                              <Property Name="RequiredInForms" Type="System.Boolean">true</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                        </TypeDescriptors>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </Parameter>
              </Parameters>
              <MethodInstances>
                <MethodInstance Type="SpecificFinder" ReturnParameterName="Read Item" ReturnTypeDescriptorPath="Read Item[0]" Default="true" Name="Read Item" DefaultDisplayName="Consignees Read Item">
                  <Properties>
                    <Property Name="LastDesignedOfficeItemType" Type="System.String">None</Property>
                  </Properties>
                  <AccessControlList>
                    <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                      <Right BdcRight="Edit" />
                      <Right BdcRight="Execute" />
                      <Right BdcRight="SetPermissions" />
                      <Right BdcRight="SelectableInClients" />
                    </AccessControlEntry>
                  </AccessControlList>
                </MethodInstance>
              </MethodInstances>
            </Method>
            <Method Name="Update" DefaultDisplayName="Consignees Update">
              <Properties>
                <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
                <Property Name="RdbCommandText" Type="System.String">UPDATE [dbo].[tableName] SET [Name] = @Name , [Address1] = @Address1 , [Address2] = @Address2 , [Address3] = @Address3 , [Address4] = @Address4 , [PostCode] = @PostCode WHERE [ConsigneeID] = @ConsigneeID</Property>
                <Property Name="BackEndObjectType" Type="System.String">SqlServerTable</Property>
                <Property Name="BackEndObject" Type="System.String">tableName</Property>
                <Property Name="Schema" Type="System.String">dbo</Property>
              </Properties>
              <AccessControlList>
                <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                  <Right BdcRight="Edit" />
                  <Right BdcRight="Execute" />
                  <Right BdcRight="SetPermissions" />
                  <Right BdcRight="SelectableInClients" />
                </AccessControlEntry>
              </AccessControlList>
              <Parameters>
                <Parameter Direction="In" Name="@ConsigneeID">
                  <TypeDescriptor TypeName="System.Int32" UpdaterField="true" IdentifierName="ConsigneeID" Name="ConsigneeID" />
                </Parameter>
                <Parameter Direction="In" Name="@Name">
                  <TypeDescriptor TypeName="System.String" UpdaterField="true" Name="Name">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">100</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@Address1">
                  <TypeDescriptor TypeName="System.String" UpdaterField="true" Name="Address1">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">100</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@Address2">
                  <TypeDescriptor TypeName="System.String" UpdaterField="true" Name="Address2">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">100</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@Address3">
                  <TypeDescriptor TypeName="System.String" UpdaterField="true" Name="Address3">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">100</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@Address4">
                  <TypeDescriptor TypeName="System.String" UpdaterField="true" Name="Address4">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">50</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="In" Name="@PostCode">
                  <TypeDescriptor TypeName="System.String" UpdaterField="true" Name="PostCode">
                    <Properties>
                      <Property Name="Size" Type="System.Int32">10</Property>
                    </Properties>
                    <Interpretation>
                      <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                    </Interpretation>
                  </TypeDescriptor>
                </Parameter>
              </Parameters>
              <MethodInstances>
                <MethodInstance Type="Updater" Name="Update" DefaultDisplayName="Consignees Update">
                  <AccessControlList>
                    <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                      <Right BdcRight="Edit" />
                      <Right BdcRight="Execute" />
                      <Right BdcRight="SetPermissions" />
                      <Right BdcRight="SelectableInClients" />
                    </AccessControlEntry>
                  </AccessControlList>
                </MethodInstance>
              </MethodInstances>
            </Method>
            <Method Name="Delete" DefaultDisplayName="Consignees Delete">
              <Properties>
                <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
                <Property Name="RdbCommandText" Type="System.String">DELETE FROM [dbo].[tableName] WHERE [ConsigneeID] = @ConsigneeID</Property>
                <Property Name="BackEndObjectType" Type="System.String">SqlServerTable</Property>
                <Property Name="BackEndObject" Type="System.String">tableName</Property>
                <Property Name="Schema" Type="System.String">dbo</Property>
              </Properties>
              <AccessControlList>
                <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                  <Right BdcRight="Edit" />
                  <Right BdcRight="Execute" />
                  <Right BdcRight="SetPermissions" />
                  <Right BdcRight="SelectableInClients" />
                </AccessControlEntry>
              </AccessControlList>
              <Parameters>
                <Parameter Direction="In" Name="@ConsigneeID">
                  <TypeDescriptor TypeName="System.Int32" IdentifierName="ConsigneeID" Name="ConsigneeID" />
                </Parameter>
              </Parameters>
              <MethodInstances>
                <MethodInstance Type="Deleter" Name="Delete" DefaultDisplayName="Consignees Delete">
                  <AccessControlList>
                    <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                      <Right BdcRight="Edit" />
                      <Right BdcRight="Execute" />
                      <Right BdcRight="SetPermissions" />
                      <Right BdcRight="SelectableInClients" />
                    </AccessControlEntry>
                  </AccessControlList>
                </MethodInstance>
              </MethodInstances>
            </Method>
            <Method Name="Read List" DefaultDisplayName="Consignees Read List">
              <Properties>
                <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
                <Property Name="RdbCommandText" Type="System.String">SELECT TOP(@ConsigneeID) [ConsigneeID] , [Name] , [Address1] , [Address2] , [Address3] , [Address4] , [PostCode] FROM [dbo].[tableName] ORDER BY [ConsigneeID]</Property>
                <Property Name="BackEndObjectType" Type="System.String">SqlServerTable</Property>
                <Property Name="BackEndObject" Type="System.String">tableName</Property>
                <Property Name="Schema" Type="System.String">dbo</Property>
              </Properties>
              <AccessControlList>
                <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                  <Right BdcRight="Edit" />
                  <Right BdcRight="Execute" />
                  <Right BdcRight="SetPermissions" />
                  <Right BdcRight="SelectableInClients" />
                </AccessControlEntry>
              </AccessControlList>
              <FilterDescriptors>
                <FilterDescriptor Type="Limit" FilterField="ConsigneeID" Name="Limit">
                  <Properties>
                    <Property Name="UsedForDisambiguation" Type="System.Boolean">false</Property>
                    <Property Name="IsDefault" Type="System.Boolean">false</Property>
                    <Property Name="CaseSensitive" Type="System.Boolean">false</Property>
                  </Properties>
                </FilterDescriptor>
              </FilterDescriptors>
              <Parameters>
                <Parameter Direction="In" Name="@ConsigneeID">
                  <TypeDescriptor TypeName="System.Int64" AssociatedFilter="Limit" Name="ConsigneeID">
                    <DefaultValues>
                      <DefaultValue MethodInstanceName="Read List" Type="System.Int64">100</DefaultValue>
                    </DefaultValues>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="Return" Name="Read List">
                  <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="Read List">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Read ListElement">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.Int32" ReadOnly="true" IdentifierName="ConsigneeID" Name="ConsigneeID" />
                          <TypeDescriptor TypeName="System.String" Name="Name">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">100</Property>
                              <Property Name="RequiredInForms" Type="System.Boolean">true</Property>
                              <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="Address1">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">100</Property>
                              <Property Name="RequiredInForms" Type="System.Boolean">true</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="Address2">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">100</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="Address3">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">100</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="Address4">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">50</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                          <TypeDescriptor TypeName="System.String" Name="PostCode">
                            <Properties>
                              <Property Name="Size" Type="System.Int32">10</Property>
                              <Property Name="RequiredInForms" Type="System.Boolean">true</Property>
                            </Properties>
                            <Interpretation>
                              <NormalizeString FromLOB="NormalizeToNull" ToLOB="NormalizeToNull" />
                            </Interpretation>
                          </TypeDescriptor>
                        </TypeDescriptors>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </Parameter>
              </Parameters>
              <MethodInstances>
                <MethodInstance Type="Finder" ReturnParameterName="Read List" Default="true" Name="Read List" DefaultDisplayName="Consignees Read List">
                  <Properties>
                    <Property Name="UseClientCachingForSearch" Type="System.String"></Property>
                    <Property Name="RootFinder" Type="System.String"></Property>
                  </Properties>
                  <AccessControlList>
                    <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
                      <Right BdcRight="Edit" />
                      <Right BdcRight="Execute" />
                      <Right BdcRight="SetPermissions" />
                      <Right BdcRight="SelectableInClients" />
                    </AccessControlEntry>
                  </AccessControlList>
                </MethodInstance>
              </MethodInstances>
            </Method>
          </Methods>
        </Entity>
      </Entities>
    </LobSystem>
  </LobSystems>
</Model>
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
QPRCommented:
How about if you open the sharepoint site (in browser) go to "view all site content" find your external list and attempt to open it. Any luck?
Just trying to take a couple of things out of the equation (web parts, SP designer)
0
 
ebooyensConnect With a Mentor Author Commented:
No sorry, that does the same.  Thanks for your help but I give up, I'll try using a different SP site on a different server and a different SQL server, start from scratch and see how it goes.
0
 
ebooyensAuthor Commented:
No sorry, that does the same.  Thanks for your help but I give up, I'll try using a different SP site on a different server and a different SQL server, start from scratch and see how it goes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.