Resource or Limit error (BDE error message)

7 comments. Current rating: (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.

Comments:

2006-04-21, 02:09:33

a_yeesunket@hotmail.com from Thailand

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

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 This image was also posted here: BDE error codes BDE error codes BDE error codes 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 Off-topic Very Helpful Helpful Ok article Not useful Very bad	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. Add a picture: