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 ...
Get Microsoft® Office SharePoint® Server 2007 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
