Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.