Layer in Use- Maximum number of streams exceeded

Error Message

Looping through a recordset using IFeatureCursor may cause the following error:

"Layer in Use- Maximum number of streams exceeded"

Cause

Garbage collection takes care of releasing resources in managed code. This process is non-deterministic and will release resources at some undetermined time. In most cases this approach works fine, however in this situation it is necessary to mark the COM object as eligible for garbage collection so the resources will be released in a timely manner.

Solution or Workaround

1. At the top of the class module add the namespace as shown below:
   
   
   

   Code:
   C#: 
   using System.Runtime.InteropServices; 
   
   VB.Net: 
   Imports System.Runtime.InteropServices

   
   
2. In the method using the FeatureCursor, add the following code to mark the feature cursor as eligible for garbage collection.
   
   

   Code:
   Marshal.ReleaseComObject(pFeatCursor)