Export (0) Print
Expand All

SQLLinkedCatalogs

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


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

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.

SUCCEED or FAIL.

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.

Community Additions

ADD
Show:
© 2014 Microsoft