다음을 통해 공유

  • 아티클

ValidateDataSource Method

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The ValidateDataSource method attempts a connection to the indicated data source using the login name and password specified.

구문

object
.ValidateDataSource(
DataSource
, 
Login
,
Password
,
[ SubscriberType ] )

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • DataSource
    Identifies an ODBC data source by name.

  • Login
    Specifies a Microsoft SQL Server login by name.

  • Password
    Password for the specified SQL Server login.

  • SubscriberType
    Optional. A long integer that identifies the Subscriber data source implementation as described in Settings.

Prototype (C/C++)

HRESULT ValidateODBCDataSource(
SQLDMO_LPCSTR DataSourceName,
SQLDMO_LPCSTR Login,
SQLDMO_LPCSTR Password,
SQLDMO_SUBSCRIBER_TYPE SubscriberType = SQLDMOSubInfo_ODBCDatasource);

Settings

Set SubscriberType using these SQLDMO_SUBSCRIBER_TYPE values.

Constant

Value

Description

SQLDMOSubInfo_/ExchangeServer

4

Type property of RegisteredSubscriber object that identifies a Microsoft Exchange Server installation persisted as a SQL Server linked server.

SQLDMOSubInfo_JetDatabase

2

Name property of RegisteredSubscriberobject identifies a Microsoft Jet version 3.5 database

SQLDMOSubInfo_/ODBCDatasource

1

Name property of RegisteredSubscriber object identifies an ODBC user or system DSN.

SQLDMOSubInfo_/OLEDBDatasource

3

Type property of RegisteredSubscriber object that identifies an OLE DB data source specification, or Microsoft Jet version 4.0 database persisted as a SQL Server linked server.

SQLDMOSubInfo_SQLServer

0

Name property of RegisteredSubscriber object identifies an instance of SQL Server by SQL Server name.

주의

If the ValidateDataSource method succeeds, the data source specified can be targeted in a subscription. The error SQLDMO_E_INVALIDDSN is raised when a connection is not made to the data source or the data source specified cannot otherwise receive a subscription.

Applies To:

Replication Object