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
Microsoft® 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.