Share via

ValidateDataSource Method

  • Article

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 ValidateDataSource method attempts a connection to the indicated data source using the login name and password specified.

Syntax

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 RegisteredSubscriber object 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.

Remarks

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