memory problems

[jbrowne]

Hi all,
I am trying to load a list box with records from a Pervasive/Btrieve database using ADO and the Pervasive OLEDB provider. There is 3600 records to go in the list box but my program is crashing out with a "not enough storage is available to complete this operation" error. I also got an "overflow" error. I can trap both of these but trapping a 'memory problem' and just resuming the code tends not to be very good practice and can cause unforeseen problems with the rest of a program.As I see it, the memory problem is either;
(i) a VB6 memory problem because of such a big operation,
(ii) the list box won't hold that many records and is throwing the error or
(iii) the Pervasive OLEDB Provider is having memory problems because of the size of the operation.
Can anyone help me out here ??

Thanks in advance
John B

 

[essa2000]

Dear jhon ,
Please , run your program on different systems and then monitor that errors. May be the problem is just with your system.

1) 3600 records are not too many.
2) list box can contain the records as the lenght of a long datatype.

I have checked the list box and i have populated 18400 records using ADO and ODBC. The overflow error may with the Itemdata of list box . You were trying to maintain the ID in itemdata also.
Hence , please check your programm with ODBC and on different PC's.

Regards ,
essa2000