The ValidateDataSource method attempts a connection to the indicated data source using the login name and password specified.
object.ValidateDataSource( DataSource , Login , Password ,
[ SubscriberType ] )
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™ 2000 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.
HRESULT ValidateODBCDataSource(
SQLDMO_LPCSTR DataSourceName,
SQLDMO_LPCSTR Login,
SQLDMO_LPCSTR Password,
SQLDMO_SUBSCRIBER_TYPE SubscriberType = SQLDMOSubInfo_ODBCDatasource);
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 |
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.