Posts Tagged SharePoint Server SDK

Installing and configuring the “Application Definition Designer” tool – BDC

Everyone knows about the usage of Application Definition Designerthis is a Microsoft tool that comes with the SharePoint Server SDK. You can see the overview and the system requirements here. While installing this tool I have faced few problems, so I just wanted to keep the steps in my bolg.

Step 1: Download the tool and double click the “OfficeServerSDK.exe”, You will be getting this screen.

Step 2: Click Next 😦

Step 3: The Office SharePoint Server 2007 SDK has been successfully installed. Great!

Step 4: Navigate to SDK installation path\Tools\BDC Definition Editor\. The default installation path for the MOSS SDK is <%Program Files%>\2007 Office System Developer Resources\. For me this is the path..

C:\Program Files \2007 Office System Developer Resources\Tools\BDC Definition Editor

Step 5: In this directory, double click the setup.exe

Please Note: If you double click  the BDCStudioSetup.msi file directly, Instead of clicking setup.exe then you will get this error This happened to me when I installed! 🙂

Step 6: Click Accept and continue, this will configure the SQL client.

Step 7: Click Next and close! 🙂

Step 8: That’s all, you can run the “ApplicationDefinitionDesigner.exe” in the “All Programs”

Step 9: We are ready to create the ADF (Application Definition File) to configure the BDC (Business Data Catalog) now.

Thanks. R./

References:

1. http://www.microsoft.com/en-us/download/details.aspx?id=79

2. http://nareshbojja.wordpress.com/2008/09/08/setparent-failed-for-database/

Advertisements

, , , , , , , , ,

3 Comments

There are no Business Data Types loaded in the Catalog – Business Data Type Picker

I was working on BDC (Business Data Catalog), to display the user profile data from SQL Server in SharePoint 2007. I was using “Application Definition Designer”  (A Microsoft tool that comes with the SharePoint Server SDK, you can see the installation and configuration here) to generate the ADF (Application Definition File). I tried to access the Business Data Types on the SharePoint page and then I have got the following wired error message. 🙂

BDC is not a really new stuff, so I tried to find the solution on the web but I didn’t get any direct solution immediately. Most of them are suggested to check the permission but I have adequate permission for BDC. Finally I have got the solution form this thread. Actually this is a bug in the Application Definition Designer and I don’t really know why it’s still there!

There might be two reasons to getting this error.

1. Not having enough permission to access the BDC

2. The “Finder” method is not generating properly in the “MethodInstanceType” property.

In my case I had adequate permisioion for the BDC, so the  “Finder” method was my problem.

You can see the “MethodInstanceType” property has “IdEnumerator” method instead of the “Finder”. So just click the drop down list and select the Finder method.

Then just export the ADF again, the Business Data Type Picker is showing the entries now huh? 🙂

References:

1. http://social.msdn.microsoft.com/forums/en-US/sharepointbdc/thread/c069a168-5dd9-4f5e-90bf-872e0ce00d28 

2. http://lightningtools.com/blog/archive/2010/08/19/there-are-no-business-data-types-loaded-in-the-catalog.aspx

, , , , , , , , , , ,

2 Comments