Re: Memory leak in ADODB Connection15::Open method
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Wed, 23 May 2007 06:40:47 -0400
amar panda wrote:
We have a client server application using ASP, ATL COM and SqlServer.
I have no comment about anything except:
//m_pConn->PutCursorLocation(ADODB::adUseClient); // NOTE: Above line
is necessary for fetching
resultsets and output parameters.
No it isn't. It makes it a little easier, but it is not necessary.
The only necessity is to consume all resultsets before attempting to
retrieve output parameter values. Using a client-side recordset is good for
this, until you have a stored procedure that returns multiple resultsets:
then you have to go back to using NextRecordset to loop through all the
resultsets before getting the output and return parameter values.
An alternative to using a client-side cursor is to open a super-efficient
firehose cursor (server-side) and use GetRows to store its data into an
array. Combined with NextRecordset, you have a solution that avoids using
the clunky ADO Cursor Library when you really don't require cursor
functionality. Of course, if you do require cursor functions (Sort, Filter,
metadata, etc.), then the client-side cursor works nicely, especially if you
disconnect it and close the connection while playing with it.
As for the memory leak, given the focus on .Net, MS will probably not be
paying too much attention to classic ADO issues. Sorry. If you feel very
strongly about it, you might open a support incident with MS Product
Support. If they determine that you are reporting a bug, they will not
charge you for the incident, even if the result is a "will not fix".
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- References:
- Memory leak in ADODB Connection15::Open method
- From: amar panda
- Memory leak in ADODB Connection15::Open method
- Prev by Date: Memory leak in ADODB Connection15::Open method
- Next by Date: Re: Non traditional database connections and datasets
- Previous by thread: Memory leak in ADODB Connection15::Open method
- Next by thread: Re: Non traditional database connections and datasets
- Index(es):
Relevant Pages
|
|
