PipelineComponent.ReleaseConnections Method

Article
12/03/2008

Frees the connections established during AcquireConnections. Called at design time and run time.

Namespace: Microsoft.SqlServer.Dts.Pipeline
Assembly: Microsoft.SqlServer.PipelineHost (in microsoft.sqlserver.pipelinehost.dll)

Syntax

'Declaration
Public Overridable Sub ReleaseConnections

public virtual void ReleaseConnections ()

public:
virtual void ReleaseConnections ()

public void ReleaseConnections ()

public function ReleaseConnections ()

Remarks

Called repeatedly during component design, and at the end of component execution. Components should release any connections that were opened and maintained in AcquireConnections.

Example

private System.Data.OleDb.OleDbConnection oledbConnection;
public override void ReleaseConnections()
{
    if (oledbConnection != null && oledbConnection.State != ConnectionState.Closed )
        oledbConnection.Close();
}

Private oledbConnection As System.Data.OleDb.OleDbConnection 

Public Overrides Sub ReleaseConnections() 
 If Not (oledbConnection Is Nothing) AndAlso Not (oledbConnection.State = ConnectionState.Closed) Then 
   oledbConnection.Close 
 End If 
End Sub

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via