Gunnar Peipman's ASP.NET blog

ASP.NET, C#, SharePoint, SQL Server and general software development topics.

Sponsors

News

 
 
 
DZone MVB

Links

Social

Database Error When Installing BDC Definition Editor

To make your life easier when creating BDC application definitions you can use BDC Definition Editor that comes with SharePoint Server SDK. You have to install it separately after installing SDK. Installer is located in SDK installation directory.

I had some troubles when installing BDC Definition Editor. You can see error message on the picture below (run setup.exe to install DBC Definition Editor).

BDC Editor - Database error

Two things to check out if you get the same error:

  1. Check out if MS SQL Server (no matter if Express edition or higher) instance called BDC is installed. If there is no instance called BDC then install new instance of SQL Server and call it as BDC.
  2. If you see the instance already then make sure it is started. On my virtual machine installer somewhy wasn't able to start required SQL Server instance so I had to do it manually.

One thing you should know is that install may take long time. So after starting setup and starting installation you may have a cup of coffee or anything else you like and wait or go out with your dog :)

Posted: Jul 06 2008, 11:16 AM by DigiMortal | with 4 comment(s)

Comments

Jonas Nilsson said:

If you don't have MOSS Enterprise and want to have BDC functionality check out this FREE platform.

community.bamboosolutions.com/.../default.aspx

We welcome feedback since we are commited to be community driven.

What features are you missing in the BDC, we will put them in MashPoint.

Do you want to be able to consume REST "based" Web Services, import your domain models? You can use any .NET class as a data provider in MashPoint. No need to write "WebService facades".

MashPoint is also of interest for ISV and consultants that already target the BDC. Why? If you use the MashPoint wrappers your code will run on both the BDC and MashPoint without changes.

Thanks

/Jonas Nilsson

# July 7, 2008 7:24 PM

Arné said:

I reckon no even bother with the MS editor, it's really low quality product for me personally. I'll rather go the BDC manager(the trial is free) or other 3rd party tools.

# July 8, 2008 12:12 PM

ved said:

U rock man.. u saved my time....

Even my BDC instance was stopped.

# August 2, 2008 5:55 AM

Fred Morrison said:

I can't get the Microsoft BDC Editor to work after a week of trying it on the AdventureWorks database.  It's totally worthless and a waste of time.  If Microsoft ever wants to know what's slowing down the rate of adoption of BDC, providing crappy tools is the pimary reason.  I shouldn't have to waste my time figuring out various "work-arounds" for the most simple things which should already have been QA tested before it ever made its first public appearance.

# August 4, 2008 10:01 AM