Hi there!
I hope you help me to know what is happening, i have a DLL COM Object who
uses ADO and OLEDB to connect to a SQL Server DB and call several stored
procedures, actually this COM is a bussiness object who is called from a
VB Front end and an ASP page. The COM handles connection and data process
stuff and i get the data via a variant array so my front end's apps doesnt
know nothing about ADO or recordsets. The problem is that the COM Object
effectively releases ADO Connections if it is called from the VB Front
End, but if i call it from the ASP page ADO Connections are not
released!!! i dont know why, im thinking that perhaps is something related
to IIS. I close all the recordsets, disconects them and close the
connection objects, do i have to configure something in IIS to get rid of
this problem? some connection pooling stuff ?
Thanks in advance crew.
Prisciliano Quintanilla