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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QPRCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
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
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.