SQLLinkedServers
SQLLinkedServers returns a list of data sources that can participate in distributed queries.
Syntax
SQLRETURN SQLLinkedServers(
SQLHSTMT hstmt)
Arguments
- hstmt
Is an ODBC statement handle.
Returns
SUCCEED or FAIL.
Comments
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.
See Also
Reference
Schema Functions Supporting Distributed Queries