Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Schema Functions Supporting Distributed Queries

SQL Server 2005

The SQL Native Client ODBC driver provides extended catalog functions that support SQL Server distributed queries.

The catalog functions SQLLinkedCatalogs and SQLLinkedServers list data sources available for distributed query. A linked server is an OLE DB data source. For the ODBC application, the name of the linked server can qualify tables and columns in a query. SQL Server distributes the query as required.

The extended functions are implemented in the SQL Native Client ODBC driver. The application developer links with sqlncli.lib to build an application by using SQLLinkedCatalogs or SQLLinkedServers.

In addition, the SQL Native Client ODBC driver supports using several standard ODBC functions to get catalog information for tables or linked servers.

Community Additions

ADD
Show:
© 2015 Microsoft