ValidateDataSource 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 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 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. |
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.