Configure
a linked server to enable the SQL Server Database Engine to execute commands
against OLE DB data sources outside of the instance of SQL Server. Typically
linked servers are configured to enable the Database Engine to execute a
Transact-SQL statement that includes tables in another instance of SQL Server,
or another database product such as Oracle.
A linked server definition specifies
the following objects:
- An OLE DB provider
- An OLE DB data source
An OLE DB provider is a DLL that manages and interacts with a
specific data source. An OLE DB data source identifies the specific database
that can be accessed through OLE DB. Although data sources queried through
linked server definitions are ordinarily databases, OLE DB providers exist for
a variety of files and file formats. These include text files, spreadsheet
data, and the results of full-text content searches.
The Microsoft SQL
Server Native Client OLE DB Provider (PROGID: SQLNCLI11) is the official
OLE DB provider for SQL Server.
No comments:
Post a Comment