New Information - SQL Server 2000 SP3.
The odbcping utility tests the integrity of an ODBC data source and the ability of the client to connect to a server.
Syntax
odbcping
[/?] |
[
{
-Sserver_name[\instance_name]
| -Ddata_source
}
[-Ulogin_id]
[-Ppassword]
]
Arguments
/?
Displays the odbcping syntax diagram.
-Sserver_name
Is the instance of Microsoft® SQL Server™ 2000 to connect to. Specify server_name to connect to the default instance of SQL Server 2000 on that server. Specify server_name\instance_name to connect to a named instance of SQL Server 2000 on that server. The connection is made without testing any ODBC data source.
-Ddata_source
Is the name of an ODBC data source defined to use the SQL Server ODBC driver. odbcping verifies that the data source is correct by using it to connect to the server named in the data source.
-Ulogin_id
Is a valid login ID for the server.
-Ppassword
Is the password for login_id.
Security Note The password will not be masked.