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

SQLLinkedServers

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

SQLRETURNSQLLinkedServers(SQLHSTMThstmt)
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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.