SQL-DMO
EnumDataSourceNames Method
The EnumDataSourceNames method returns a QueryResults object that enumerates data sources visible to an instance of Microsoft® SQL Server™ 2000 participating in replication as a Publisher.
Applies To
| Replication Object |
Syntax
object.EnumDataSourceNames( ) as QueryResults
Parts
object
Expression that evaluates to an object in the Applies To list
Prototype (C/C++)
HRESULT EnumDataSourceNames(
LPSQLDMOQUERYRESULTS* ppResults);
Returns
A QueryResults object that contains one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
| Data Source Name | nvarchar(129) | Name of the data source. Interpret and use the name based on the value of the Type column. |
| Description | varchar(512) | Descriptive text. |
| Type | integer | Type of data source. 1 equals ODBC. 3 equals OLE DB. |
| Provider Name | varchar(512) | When Type is 3, contains the name of the OLE DB provider. Empty when Type is 1. |