Share via


SQLLinkedCatalogs

SQLLinkedCatalogs returns a list of catalogs available on a linked server.

Syntax

SQLRETURN SQLLinkedCatalogs(
      SQLHSTMT hstmt,
      SQLTCHAR* ServerName,
   SQLSMALLINTNameLength1)

Arguments

  • hstmt
    Is an ODBC statement handle.
  • ServerName
    Is the name of the linked server. Linked server names are returned in the SRV_NAME column of the result set defined for SQLLinkedServers.
  • NameLength1
    Is the length of ServerName, in characters.

Returns

SUCCEED or FAIL.

Comments

SQL Server linked servers are OLE DB data sources. Some OLE DB data sources expose catalogs. For those that do, SQLLinkedCatalogs returns the list of data source exposed catalogs.

SQLLinkedCatalogs returns a result set defined as follows.

Column name Column number Data type Comments

CATALOG_NAME

1

SQLWCHAR

Name of the catalog.

DESCRIPTION

2

SQLWCHAR

Human-readable description of the catalog.

See Also

Reference

Schema Functions Supporting Distributed Queries

Help and Information

Getting SQL Server 2005 Assistance