B
ben
I am having problems with old COM components that I must use in my
ASP.NET project leavings connections open in the SQL server "Process
Info" with "AWAITING COMMAND".
After some testing I have determined that .NET is not correctly
calling the Class_Terminate in the old COM componet which would close
the connection.
I have tested this with my own API and found that I must expose a
method that allows me to manually clos the SQL connection, so just
before I set the object to nothing I call the .CloseDBConn() - this
works.
The problems is that the APIs I am using are written by third-party
software vendors so I cannot modify them.
I have read that the Garbage Collector is supposed to get rid of these
connections but it doesn't appear to. With every refresh of the
browser so another connection (or two) is born, hundreds will appear
and never disappear.
Hope someone can shed some light on this.
ASP.NET project leavings connections open in the SQL server "Process
Info" with "AWAITING COMMAND".
After some testing I have determined that .NET is not correctly
calling the Class_Terminate in the old COM componet which would close
the connection.
I have tested this with my own API and found that I must expose a
method that allows me to manually clos the SQL connection, so just
before I set the object to nothing I call the .CloseDBConn() - this
works.
The problems is that the APIs I am using are written by third-party
software vendors so I cannot modify them.
I have read that the Garbage Collector is supposed to get rid of these
connections but it doesn't appear to. With every refresh of the
browser so another connection (or two) is born, hundreds will appear
and never disappear.
Hope someone can shed some light on this.