SharePoint 2010: BDC doesn't work with SQL 2000

I'm at a client site. They have data on a SQL 2000 DB. We want to expose this to SharePoint 2010. Sounds like a simple task of creating BDC connection. Great!

But no. Apparently there isn't support for SQL 2000 in SharePoint 2010 BDC.

Humph...

The discussion on the MSDN forum. (Look at the bottom).

Also worth a look at this article, specifically the comments: MSDN Article

Blog move

Hi everyone,
Just a quick note that I have moved my blog from http://soreeyesdotnet.blogspot.com/ to http://sharepointchan.blogspot.com/

All posts have been copied across and I will be keeping the old blog around in case anyone has links pointing to my posts.

Regards,
Chan

Colour coding text in Blog posts

I found this great site: http://www.hilite.me/

It will generate html for you so your code can be displayed in all it's colourful glory.

Loving it!

SharePoint 2010: Web Part Properties

Even though I've made SP2010 web parts before for some reason I couldn't find any good articles on how to add Custom Properties to a web part.

So here is my take on a Custom SharePoint 2010 Web Part Property:

private string _targetSite = "SomeSite";
[Personalizable(PersonalizationScope.Shared),
WebBrowsable(true),
WebDisplayName("Target Site"),
WebDescription("Specify a site."),
Category("Configuration")]
public string TargetSite
{
get { return _targetSite; }
set { _targetSite = value; }
}

Oh and make sure you have the permissions to change settings.