ValidateDataSource Method
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The ValidateDataSource method attempts a connection to the indicated data source using the login name and password specified.
Syntaxe
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. |
Notes
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.