EnumDataSourceNames Method
未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。
The EnumDataSourceNames method returns a QueryResults object that enumerates data sources visible to an instance of Microsoft SQL Server participating in replication as a Publisher.
語法
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. |