Informix Memory Leak

I am running into an strange issue using Informix (specifically, I am using the IBM.Data.Informix namespace, 4.10 Client SDK). I am connecting to an IBM Informix database using OD

Solution 1:

Turns out that this is an issue with the specific version of the SDK I am using for the project (4.10 - 32 bit). Unless you leave both the connection and the command open indefinitely, the application will leak memory. This isn't really a solution because there is a finite number of connections and that quickly runs out if I have multiple connections to the application. Because I need to continue using this specific SDK version, I configured IIS to recycle the app pool when it reached a memory threshold (1 GB in my instance). That resolved the issue for now, although it does nothing to address the underlying issue with the SDK.