Ask a question

Search Forums:

• Search SharePoint - Business Data Catalog (pre-SharePoint 2010) Forum
• Search All SharePoint Products and Technologies Forums
• Search All Microsoft TechNet Forums

 

Cannot import ADF using BDC

• Sunday, October 18, 2009 11:48 AMgophette

   
  

  0

  Sign In to Vote
  Hi,
  I'm trying to import and ADF using using business Data Catalog but when I click "

  Import application definition" and chose my file bdc.adworks.hr; I can read "Start" on the page.
  But it ramain on the step Start and import never finish ; I've no errors
  Sometimes I have : Validating application definition ,
  Why ?
  My server name is TOCANE (MOSS is intalled on it) and my database name is AdventureWorks
  Here is my File ADF :
  
  

  <?

   

  xml version="1.0" encoding="utf-8"?>

  <

   

  LobSystem xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog" Type="Database" Version="1.0.0.0" Name="AdventureWorksHumanResources">

  <

   

  LobSystemInstances>

  <

   

  LobSystemInstance Name="AdventureWorksHumanResourcesWebInstance">

  <

   

  Properties>

  <

   

  Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">

  PassThrough

  </

   

  Property>

  <

   

  Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">

  SqlServer

  </

   

  Property>

  <

   

  Property Name="RdbConnection Data Source" Type="System.String">TOCANE</Property>

  <

   

  Property Name="RdbConnection Initial Catalog" Type="System.String">AdventureWorks</Property>

  <

   

  Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property>

  </

   

  Properties>

  </

   

  LobSystemInstance>

  </

   

  LobSystemInstances>

  <

   

  Entities>

  <

   

  Entity Name="Department">

  <

   

  Methods>

  <

   

  Method Name="GetDepartments">

  <

   

  Properties>

  <

   

  Property Name="RdbCommandText" Type="System.String">

  select DepartmentID, [Name] as [Service], GroupName as

  Department, ModifiedDate

  from HumanResources.Department

  </

   

  Property>

  <

   

  Property Name="RdbCommandType" Type="System.Data.CommandType">Text</Property>

  </

   

  Properties>

  <

   

  Parameters>

  <

   

  Parameter Direction="Return" Name="Departments">

  <

   

  TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral,PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="DepartmentDataReader">

  <

   

  TypeDescriptors>

  <

   

  TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral,PublicKeyToken=b77a5c561934e089" Name="DepartmentDataRecord">

  <

   

  TypeDescriptors>

  <

   

  TypeDescriptor TypeName="System.Int16" Name="DepartmentID"/>

  <

   

  TypeDescriptor TypeName="System.String" Name="Service"/>

  <

   

  TypeDescriptor TypeName="System.String" Name="Department"/>

  <

   

  TypeDescriptor TypeName="System.DateTime" Name="ModifiedDate"/>

  </

   

  TypeDescriptors>

  </

   

  TypeDescriptor>

  </

   

  TypeDescriptors>

  </

   

  TypeDescriptor>

  </

   

  Parameter>

  </

   

  Parameters>

  <

   

  MethodInstances>

  <

   

  MethodInstance Name="DepartmentFinderInstance" Type="Finder" ReturnParameterName="Departments" />

  </

   

  MethodInstances>

  </

   

  Method>

  </

   

  Methods>

  </

   

  Entity>

  </

   

  Entities>

  </

   

  LobSystem>

  • Reply
  • Quote