DelphiFAQ Home Search:

Resource or Limit error (BDE error message)

 

comments7 comments. Current rating: 5 stars (2 votes). Leave comments and/ or rate it.

Question:
What does BDE error 37 (0025 hex) aka 'Resource or Limit error ' mean?

Answer:
Here is a list of possible explanations for this situation:


9473 : $2501 : Insufficient memory for this operation.
9474 : $2502 : Not enough file handles.
9475 : $2503 : Insufficient disk space.
9476 : $2504 : Temporary table resource limit.
9477 : $2505 : Record size is too big for table.
9478 : $2506 : Too many open cursors.
9479 : $2507 : Table is full.
9480 : $2508 : Too many sessions from this workstation.
9481 : $2509 : Serial number limit (Paradox).
9482 : $250A : Some internal limit (see context).
9483 : $250B : Too many open tables.
9484 : $250C : Too many cursors per table.
9485 : $250D : Too many record locks on table.
9486 : $250E : Too many clients.
9487 : $250F : Too many indexes on table.
9488 : $2510 : Too many sessions.
9489 : $2511 : Too many open databases.
9490 : $2512 : Too many passwords.
9491 : $2513 : Too many active drivers.
9492 : $2514 : Too many fields in Table Create.
9493 : $2515 : Too many table locks.
9494 : $2516 : Too many open BLOBs.
9495 : $2517 : Lock file has grown too large.
9496 : $2518 : Too many open queries.
9497 : $2519 : Too many threads for client.
9498 : $251A : Too many BLOBs.
9499 : $251B : File name is too long for a Paradox version 5.0 table.
9500 : $251C : Row fetch limit exceeded.
9501 : $251D : Long name not allowed for this tablelevel.
9502 : $251E : Insufficient shared memory available.

Content-type: text/html

Comments:

2006-04-21, 02:09:33
a_yeesunket@hotmail.com from Thailand  
rating
error no 9476 temporary table resource limit

my data has 2000000 record from my sql statement
i use clientdataset for recieve data it just error
but i can select it in dbexplorer
2007-12-11, 03:43:37
anonymous from Thailand  
9495 : $2517 : Lock file has grown too large.

what can I do.?
2008-02-13, 22:23:13
anonymous from Australia  
You can only lock 255 records at once.
2008-11-10, 06:36:08
anonymous from Bulgaria  
9485 : $250D : Too many record locks on table.
What's the limit? Is it the same as 9495 : $2517 : Lock file has grown too large.???
2008-11-10, 09:43:59
anonymous from Bulgaria  
9485 : $250D : Too many record locks on table.


What's the limit?

Is it the same as
9495 : $2517 : Lock file has grown too large.???
2009-03-27, 05:46:02
winslet.jessica@gmail.com from India  
rating
i have a problem with delphi 7 with bde and oracle 9i , delphi show message that the index note exist but the index is exist realy.
http://www.thetopga..gsite.com



Keywords:
2010-02-03, 00:20:06
anonymous from Philippines  
We have an app build on Delphi 7 that uses MSSQL database and from time to time our clients are experiencing 'Lock file has grown too large' problem on their side.
All the threads that post solutions to this were pointing to a paradox issues. But we dont use paradox tables and we only uses pure sql procedures. I was wondering why the lock file has grown too large even though we are using MSSQL?

CAn you help me sort this out?

Thanks in advance.

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: