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
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