Hello,
We are trying to troubleshoot some DB problems from COM objects that call ADO. I heard that when ADO is loaded inside of a COM object by a .NET app, that .NET intercepts the call and re-maps those calls over to ADO.NET. This seems untrue to me, given the nature of ADO.NET being a totally separate technology.
Does anyone know for sure whether this does or does not occur?
The problem we are seeing is actually almost identical in symptoms to this:
http://support.microsoft.com/default.aspx/kb/230101
"FIX: Data Queries Sporadically Return Empty Recordsets"
Literally, this is what is happening, but we are on MDAC 2.8, so it should not have the leak any more. I think I made another post about that, so I won't repeat it here. It makes me think there is a similar memory problem.
Thanks,
Josh
ASP.NET/C# Developer