O'Reilly logo

Microsoft® Office SharePoint® Server 2007 Administrator's Companion by The Microsoft SharePoint Community Experts, Bill English

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Accessing Data from Other Sources

Data Connection Libraries are SharePoint libraries that are similar to document libraries and are used as shared repositories for Office Data Connection (.odc) files. The .odc files were introduced in Excel Services in Microsoft Office XP as a means of storing the connection information needed by Excel to access back-end databases. Users create .odc files when they connect to an external data source, such as a SQL Server database. These files are stored, by default, in the My Data Sources folder on the user’s local drive. This arrangement prevents them from being easily shared with other users.

By creating a Data Connection Library and populating it with the standard .odc files that your users are most likely to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required