Export (0) Print
Expand All

SQLLinkedServers

SQLLinkedServers returns a list of data sources that can participate in distributed queries.


SQLRETURN SQLLinkedServers(
      SQLHSTMT hstmt)

hstmt

Is an ODBC statement handle.

SUCCEED or FAIL.

SQL Server linked servers are OLE DB data sources that can be referenced using four-part names in distributed queries. SQLLinkedServers returns the properties defining the data source as a result set. Linked servers are defined to SQL Server using the sp_addlinkedserver system stored procedure. The columns of the result set are defined as follows.

Column name Column number Data type Comments

SRV_NAME

1

SQLWCHAR

Name of the linked server.

SRV_PROVIDERNAME

2

SQLWCHAR

Friendly name of the OLE DB provider for this linked server.

SRV_PRODUCT

3

SQLWCHAR

Product name for this linked server.

SRV_DATASOURCE

4

SQLWCHAR

Name that identifies the source of the data to this provider.

SRV_PROVIDERSTRING

5

SQLWCHAR

Provider-specific string that identifies the source of the data.

SRV_LOCATION

6

SQLWCHAR

Location argument that identifies the database to this provider.

SRV_CAT

7

SQLWCHAR

Name of the catalog containing the data on the linked server.

SRV_PROVIDERSTRING is NULL when the SRV_DATASOURCE and SRV_CAT information is sufficient to identify the source of the data to the provider.

When the linked server is a server running an instance of SQL Server, SRV_DATASOURCE is the name of the server, SRV_CATALOG is the name of the database, and SRV_LOCATION is NULL.

Community Additions

ADD
Show:
© 2014 Microsoft