Insufficient memory for this operation
'Insufficient memory for this operation' errorQuestion:
Whenever I attempt to open many query or table cursors, I finally reach a point when I get an error, "Insufficient memory for this operation". What do I do?
Answer:
First, you should read the technical document at www.borland.com/devsupport/bde/ti_list/TI2751.html
Some current internal limits of BDE. This document will tell you what most of absolute BDE limits are.
IMPORTANT: If your application is not reaching one of the limits covered there and you are also getting the above error message, most likely the SHAREDMEMSIZE setting in the BDE will solve your problem. This setting will allow you to increase the BDE's internal object memory pool. A setting between 4096 and 8192 should be more than plenty.
修改BDE配置增加中间层程序响应客户端程序个数的方法
用友安易R9网络版软件在使用中,若发现某些工作站不能进入系统,提示‘无法连接中间层...’,则有可能是因为服务器因中间层连接数多造成系统资源不足导致的。 判断方法:工作站调用服务器中间层情况下,某些工作站发生连接不上中间层,且不固定,有时是这台,有时是那一台。 解决方法: 在服务器上,打开windows【控制面板】-【BDE Administrator】-【Configuration】-【System】-【INIT】,修改倒数第4项【SHAREDMEMSIZE】为默认值2048的整倍数,如4096、8192,但不能过大。最后点击‘Object’菜单下的‘Apply’保存设置。 若数据库为MS SQL Server,则还可以调节BDE设置中【TDS PACKET SIZE】来解决。在服务器上,打开windows【控制面板】-【BDE Administrator】-【Configuration】-【Drivers】-【Native】-【MSSQL】,修改倒数第2项【TDS PACKET SIZE】为默认值4096的整倍数,如8192、12288,但不能过大。最后点击‘Object’菜单下的‘Apply’保存设置 |