SQL Server Connection Constants (SQLDMO_VERIFYCONN_TYPE)
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.
SQL Server connection constants direct the action of the VerifyConnection method of the SQLServer object.
Constant |
Value |
Description |
|---|---|---|
SQLDMOConn_CurrentState |
2 |
Returns TRUE if connected. |
SQLDMOConn_LastState |
1 |
Returns TRUE if connected on last call and still connected, or if not connected on last call and still not connected. |
SQLDMOConn_/ReconnectIfDead |
6 |
Default. Attempts to reconnect the SQLServer object if the object has been connected and has lost its connection. It returns TRUE if the connection exists. |
SQLDMOConn_Valid |
7 |
All Microsoft SQL Server connection constants are combined by using an OR logical operator. |