OLE DB Provider Reference for Distributed Queries

The behavior of distributed queries against a remote table depends on the functionality of the OLE DB provider that is used to access the table. The OLE DB specification defines a set of objects for OLE DB providers. Each object has a set of interfaces. Many of these objects and interfaces are optional and may not be supported by a provider. If an OLE DB provider does not support some of these objects and interfaces, distributed query functionality that depends on these components will not work with remote tables accessed through that provider.