MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for SQL Server
The LINKEDSERVERS rowset enumerates organization data sources that can participate in Microsoft® SQL Server™ distributed queries.
The LINKEDSERVERS rowset contains the columns described in the following table.
Column name | Type indicator | Description |
SVR_NAME | DBTYPE_WSTR | Name of a linked server. |
SVR_PRODUCT | DBTYPE_WSTR | Manufacturer or other name identifying the type of data store represented by the name of the linked server. |
SVR_PROVIDERNAME | DBTYPE_WSTR | Friendly name of the OLE DB provider used to consume data from the server. |
SVR_DATASOURCE | DBTYPE_WSTR | OLE DB DBPROP_INIT_DATASOURCE string used to acquire a data source from the provider. |
SVR_PROVIDERSTRING | DBTYPE_WSTR | OLE DB DBPROP_INIT_PROVIDERSTRING value used to acquire a data source from the provider. |
SVR_LOCATION | DBTYPE_WSTR | OLE DB DBPROP_INIT_LOCATION string used to acquire a data source from the provider. |
The rowset is sorted on SRV_NAME, and a single restriction is supported on SRV_NAME.