ams4380361
asked on
Insufficient memory For This Operation
Hello,
i got the error message "Insufficient memory For This Operation" , when i stop and re-run a program that use BDE many times, what is the way to increase the BDE memory share in the total memory size.
i got the error message "Insufficient memory For This Operation" , when i stop and re-run a program that use BDE many times, what is the way to increase the BDE memory share in the total memory size.
Don't worry, whenever exception occurs, never push
the 'Program Reset' button, but the 'Run', so you
can close your application normally, and you will not
get the penalty of memory.
How do you think of my English?
the 'Program Reset' button, but the 'Run', so you
can close your application normally, and you will not
get the penalty of memory.
How do you think of my English?
Hello!
To Make the BDE use memory it needs and not giving the BDE any limits in memory usage and other things,Here are the steps:
1)Run BDE Administrator
2)go to Configuration Tab
3)Under Configuration Tab go to INIT
And Use the following options:
LOW MEMORY USAGE LIMIT: 32
MAXBUFSIZE: 2048
MAXFILEHANDLES:48
MEMSIZE: 16
MINBUFSIZE: 128
SHAREDMEMSIZE: 2048
After you set these options ,It's going to be very hard to get that pesky error message again!
Good Luck! ;-)
To Make the BDE use memory it needs and not giving the BDE any limits in memory usage and other things,Here are the steps:
1)Run BDE Administrator
2)go to Configuration Tab
3)Under Configuration Tab go to INIT
And Use the following options:
LOW MEMORY USAGE LIMIT: 32
MAXBUFSIZE: 2048
MAXFILEHANDLES:48
MEMSIZE: 16
MINBUFSIZE: 128
SHAREDMEMSIZE: 2048
After you set these options ,It's going to be very hard to get that pesky error message again!
Good Luck! ;-)
Hello Again!
Sorry!
The options in the my last post where the defualt options
Here are the options that I meant to post:
LOW MEMORY USAGE LIMIT: 65535
MAXBUFSIZE: 65535
MAXFILEHANDLES: 4096
MEMSIZE: 205
MINBUFSIZE: 65535
SHAREDMEMSIZE: 32768
Sorry!
The options in the my last post where the defualt options
Here are the options that I meant to post:
LOW MEMORY USAGE LIMIT: 65535
MAXBUFSIZE: 65535
MAXFILEHANDLES: 4096
MEMSIZE: 205
MINBUFSIZE: 65535
SHAREDMEMSIZE: 32768
ASKER
hi freshman3k
i have re-configured my BDE with your new settings , but the same problem exist ,once i open and database program 6 times, i got the same message.
i have re-configured my BDE with your new settings , but the same problem exist ,once i open and database program 6 times, i got the same message.
? ams
did you mean you run 6 instances
and the error comes up by starting the 7th instance
or
do you open/close 6 times normally your app and the error comes with the 7th try
or
do you open 6 times your app, each one after the other crashes with another error
???
to wlq,
your english is ok and
your advice is correct
meikl ;-)
did you mean you run 6 instances
and the error comes up by starting the 7th instance
or
do you open/close 6 times normally your app and the error comes with the 7th try
or
do you open 6 times your app, each one after the other crashes with another error
???
to wlq,
your english is ok and
your advice is correct
meikl ;-)
ASKER
kretzschmar ,
i run 6 instances
and the error comes up by starting the 7th instance
)
i run 6 instances
and the error comes up by starting the 7th instance
)
well,
then it could be that your error,
didn't has to do anything with the bde,
you are running just out of systermresources
(just to say that you are also cannot start unlimited instances of winword for ex.)
why does you mean, that the error is caused by the bde?
meikl ;-)
then it could be that your error,
didn't has to do anything with the bde,
you are running just out of systermresources
(just to say that you are also cannot start unlimited instances of winword for ex.)
why does you mean, that the error is caused by the bde?
meikl ;-)
ASKER
Ok ,
i know that i can't start unlimited no. of instances , but i have 200MB/256MB free , and a 3% CPU utilization, so the system is not loaded and almost free of load.
Note : using a Server with 2GB Ram , i can't start more that 20 instances. is that a shortage of memory resources.!!!!!!
i know that i can't start unlimited no. of instances , but i have 200MB/256MB free , and a 3% CPU utilization, so the system is not loaded and almost free of load.
Note : using a Server with 2GB Ram , i can't start more that 20 instances. is that a shortage of memory resources.!!!!!!
there may other resources affected (not just memory)
like gdi-resources or any kind handles
like gdi-resources or any kind handles
ASKER
Ok,
but can you explain the fact that i can run more than 22 instances of the same program if i build it using VB6.0
( the same functionality)
but can you explain the fact that i can run more than 22 instances of the same program if i build it using VB6.0
( the same functionality)
in fact,
vb shares its vbrun-dll,
where the most code is included
vb shares its vbrun-dll,
where the most code is included
ASKER
so what is the solution.!!!!!!!
what is question?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The best solution is to switch from the BDE to something else :)
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Split between kretzschmar and AvonWyss
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Paul (pnh73)
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
Split between kretzschmar and AvonWyss
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Paul (pnh73)
EE Cleanup Volunteer
After I trapped these errors (using a Try/Except), the "Insufficient memory for this operation" error did'nt come up anymore.
And, of course, you must always close a TQuery if you don't use it. In the OnClose event of all your MDI Childs close and unprepare all queries used in the MDI Child.
JDN