How to connect to SQL Data in SharePoint without using the BDC

SharePoint Dataviews - ROCK!

The BDC may be cool but it's also expensive (it's not in WSS, and in MOSS, it is only in the Enterprise product which is BIG $$).

Learned a bunch about them this week, and then learned more, by reviewing some articles presented on Microsoft's website. These were worthy of a bookmark.

More on Data View in Sharepoint Designer:

• http://office.microsoft.com/en-us/sharepointdesigner/HA101009081033.aspx


• http://office.microsoft.com/en-us/sharepointdesigner/HA100948041033.aspx

And here's a link to a filter on 'Data View' posts on the Office website.

• http://office.microsoft.com/en-us/sharepointdesigner/results.aspx?qu=%22data+view%22&av=SDR120