Click here to Skip to main content
15,885,278 members
Home / Discussions / Database
   

Database

 
GeneralPlease point me in the right direction... Pin
frank2127-Oct-03 9:00
frank2127-Oct-03 9:00 
GeneralRe: Please point me in the right direction... Pin
Aryo Handono31-Oct-03 3:15
professionalAryo Handono31-Oct-03 3:15 
Generalconnection pooling Pin
yyf27-Oct-03 7:59
yyf27-Oct-03 7:59 
GeneralRe: connection pooling Pin
Jörgen Sigvardsson30-Oct-03 9:38
Jörgen Sigvardsson30-Oct-03 9:38 
GeneralProcess SQL Transactions?? Easy Question :) Pin
mittalpa27-Oct-03 6:41
mittalpa27-Oct-03 6:41 
GeneralRe: Process SQL Transactions?? Easy Question :) Pin
Mike Dimmick28-Oct-03 2:13
Mike Dimmick28-Oct-03 2:13 
GeneralRe: Process SQL Transactions?? Easy Question :) Pin
mittalpa28-Oct-03 3:17
mittalpa28-Oct-03 3:17 
GeneralMemory Leak! Pin
Kevin Gutteridge27-Oct-03 0:36
Kevin Gutteridge27-Oct-03 0:36 
Hi All!

Can anyone help me with this? It's driving me crazy!
I've reduced a problem application down to the following lines of code.

void TestFunc()
{
::CoInitialize(NULL);

char strTEST[1024];

_ConnectionPtr spConn(__uuidof(Connection));
spConn->Open( "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=;Initial Catalog=TEST_DP;Data Source=(local)", OLESTR(""), OLESTR(""), -1 );

for ( int i = 0; i < 50000; i++ ){

strcpy( strTEST, "SELECT COUNT(*) FROM KGTEST WHERE COL1 = '" );
itoa( i, &strTEST[strlen(strTEST)], 10 );
strcat( strTEST, "'");

_RecordsetPtr spRS(__uuidof(Recordset));
spRS->CursorLocation = adUseClient;
spRS->Open( strTEST, spConn.GetInterfacePtr(), adOpenForwardOnly, adLockBatchOptimistic, -1);
spRS->Close();
spRS = NULL;

}
spConn->Close();
spConn = NULL;

::CoUninitialize();
}

This leaks memory like no tommorrow. It appears to be related to a known Microsoft problem, (Q312575) and the way that memory is cached in MDAC. However this was reported as fixed and does not occur with MDAC 2.7 (According to Microsoft, and this is running with 2.8, and I've re-installed just in case!)

The critical bit seems to be the SQL statement, if it is a constant (For example: SELECT COUNT(*) FROM KGTEST WHERE COL1 = '1' ) - everything is OK, however if the statement is constantly changing then the memory just leaks!

Can anyone shed any light on this?
GeneralRe: Memory Leak! Pin
Mike Dimmick28-Oct-03 3:00
Mike Dimmick28-Oct-03 3:00 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:03
Kevin Gutteridge28-Oct-03 22:03 
GeneralRe: Memory Leak! Pin
Mike Osbahr28-Oct-03 3:38
Mike Osbahr28-Oct-03 3:38 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:47
Kevin Gutteridge28-Oct-03 22:47 
GeneralHi All Pin
Venkatraman26-Oct-03 13:55
Venkatraman26-Oct-03 13:55 
GeneralSQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 12:58
moredip26-Oct-03 12:58 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 13:14
Edbert P26-Oct-03 13:14 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 13:22
moredip26-Oct-03 13:22 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 15:15
Edbert P26-Oct-03 15:15 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Scott.Chappel27-Oct-03 1:54
Scott.Chappel27-Oct-03 1:54 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip29-Oct-03 1:20
moredip29-Oct-03 1:20 
Generalduplication !! Pin
bora3ee26-Oct-03 11:31
bora3ee26-Oct-03 11:31 
GeneralRe: duplication !! Pin
Edbert P26-Oct-03 13:31
Edbert P26-Oct-03 13:31 
QuestionADO.NET: Is it possible to create a dataset out of a view? Pin
Rakesh Rajan26-Oct-03 1:15
Rakesh Rajan26-Oct-03 1:15 
QuestionHow to return a boolean value from a Stored Procedure? Pin
sacoskun25-Oct-03 3:38
sacoskun25-Oct-03 3:38 
AnswerRe: How to return a boolean value from a Stored Procedure? Pin
Paul Watson25-Oct-03 4:28
sitebuilderPaul Watson25-Oct-03 4:28 
QuestionWhy the connection is so slow? Pin
yyf24-Oct-03 8:46
yyf24-Oct-03 8:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.