Four-Part Name Requirements for OLE DB Providers
SQL Server 2000
Distributed queries can use four-part names only if the OLE DB provider supports:
- The IDBSchemaRowset interface.
- Restrictions on all the name parts that it supports in the IDBSchemaRowset interface. Restrictions are a mechanism defined in OLE DB for specifying the search criteria for meta data queries using the OLE DB schema rowsets.
- The literals DBLITERAL_CATALOG_SEPARATOR, DBLITERAL_SCHEMA_SEPARATOR, and DBLITERAL_QUOTE in the IDBInfo interface. Microsoft® SQL Server™ 2000 uses defaults, which may not work with providers that do not support these literals.
If an OLE DB provider does not meet these requirements, it can be referenced only using pass-through queries in the OPENDATASOURCE or OPENROWSET function.