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 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.
Applies To:
|