EnumDataSourceNames Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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.

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.

Applies To:

Replication Object