I want to try the BDC features so I created a test database with 2 tables related table (Building, Contact, Building has a foreing key to Contact). I used the Application Definition Designer furnished with the MOSS SDK to create the xml file. I was expecting
it would be easy and straightforward but the produced xml file isn't working.
I get the following error when I try to import the Application definition:
Application definition import failed. The following error occurred: Entity could not be found using criteria 'name LIKE [SP_Test].[dbo].[Contact]'. Error was encountered at or just before Line: '140' and Position: '16'.
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="220.127.116.11" Name="Building" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
<Property Name="rdbconnectionData Source" Type="System.String">MOSS2007</Property>
View Complete Post