"Insufficient Memory" when running query in Delphi 7 using BDE Paradox 7

delphi bde
user1210396 picture user1210396 · Jul 11, 2012 · Viewed 14.4k times · Source

When I run the program which is connect to a paradox database (*.db), it show error message something like project myprogram.exe raised exception class EDBEngineError with message Insufficient memory for this operation.

I use the DataSource1, Table1 and Query1 control and show the result of the Query1 to DBGrid1, the record is not greater than 100 record and the field is about 6 fields and only 1 table in the database. But the Query1 RequestLive property set to True.

I've search the web for the resolution and it shows that I need to setting the BDE administrator INIT tab to increase the ShareMemory, et al. Is it normal for me to set or maybe something wrong with the initialization of the BDE controls?

Thanks.

Answer

Adam picture Adam · Jul 11, 2012

Yes, you should increase this SHAREDMEMSIZE parameter to make it work as described here. If this is a new project, i would not recommend using paradox database. There are plenty of free databases like Firebird, Microsoft SQL Server Express, Mysql...

Related questions

How do I solve the "Cannot perform this operation on a closed dataset" with Borland Database Engine and a Delphi application?

The application was working perfectly, until I edited the user database (*.dbf) in OpenOffice.org Calc. Now it gives me the above error about a closed dataset.

Read More
BDE initialization failure (error $2501) on Vista

I have a small datasnap server written in Delphi 2007 that accesses the BDE. It works fine on Windows 2000 and XP but from time to time (actually quite regularly) on Vista I get the error message: An error occurred while attempting …

Read More
Borland Database engine on Windows 10 (1703)

Since Win10pro (1606) Borland Database Engine worked fine. I installed Win10pro build 1703 and when i run Database Desktop, it open saying that private and working dirs are invalid or undefined (administrator mode) and then, clicking OK, just closes. In …

Read More