From: joe on
I'm not aware of an ODBC solution that provides access to SharePoint list directly but you can purchase a SharePoint module from Bamboo solutions that will construct and expose a MS SQL query that can be used with ODBC to SQL to pull that data.



Posted as a reply to:

Possible to access list data using ODBC?
20-Jul-07

I have a number of lists that contain data that would be useful to access
through an odbc method. Is there a way to present the data in this form? It
doesn't have to be the fastest access ever...

Alternatively, is it possible to create a view in SQL Server 2005 that
displays the elements of a list?

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials/aspnet/ec832ac7-6e4c-4ea8-81ab-7374d3da3425/wpf-and-the-model-view-vi.aspx