ConnectionBroken Method

Description

This event method is called when the connection to SQL Server is broken.

C++

HRESULT pServerSink->ConnectionBroken (
SQLOLE_LPCSTR strBroken,
LPBOOL bRetry );

Elements

Element	Type	Description

strBroken	String	Connection broken message.
bRetry	Boolean	Determines if SQL-DMO will attempt to reestablish the broken connection. If set to True, SQL-DMO will attempt to reestablish the broken connection. If set to False, SQL-DMO will leave the connection broken, and the current operation will fail.

Remarks

If the SQLServer.AutoReConnect property is set to True, SQL-DMO will make one attempt to automatically reestablish the broken connection. If that attempt fails, the ConnectionBroken event method is called. If the SQLServer.AutoReConnect property is set to False, the ConnectionBroken event method is called immediately.