Paradox Community

Items in pnews.paradox-programming

Subject:Re: No more files
Date:1 Mar 2023 14:33:13 -0400
From:"Kevin Zawicki" <numberjack@wi.rr.com>
Newsgroups:pnews.paradox-programming



>
Oh, and I wonder if the BDE's 4GB error could be causing this.  I never had
to deal with this
so again, I don't remember the details.  I *think* it's a problem when there's
an exact multiple
of 4GB of disk space free.  (Or was it 2GB?)  The newsgroups should have
lots of discussion
on this issue.
<

I have never seen 4gb glitch through that error. It might, but usually shows
as other errors. There is a fix patch for it, but you could also add a 1gb
(or so) file in the mix to make it not even and retest.


Move everything to local drive and clean lck and net, set working drive and
priv drive local hard drive local. test.
This will eliminate network as an issue.



Liz McGuire <liz@paradoxcommunity.com> wrote:
>I agree with Kevin.  The only thing I would add is to ensure all the networking
settings
>are correct.  It's been ages since I did Paradox on a network with multiple
users...
>
>LOCAL SHARE has to be TRUE.  Oplocks (Opportunistic locking) have to be
disabled.  Disk
>caching should be disabled.
>
>Oh, and I wonder if the BDE's 4GB error could be causing this.  I never
had to deal
>with this so again, I don't remember the details.  I *think* it's a problem
when there's
>an exact multiple of 4GB of disk space free.  (Or was it 2GB?)  The newsgroups
should
>have lots of discussion on this issue.
>
>Finally, perhaps one of the BDE file limits?  MAXFILEHANDLES might need
to increase?
> (I have a doc from Mike Irwin recommending 150.  I'd probably set it to
the max -
>255.)
>
>FWIW, here are the BDE settings I always use:
>
>Configuration > System > INIT
>
>RAM AMT. (MB)    256+      128
>==============================
>LOCAL SHARE      TRUE     TRUE  *******VITAL
>MAXBUFSIZE =    65536    32768
>MEMSIZE    =      180       84
>MINBUFSIZE =     4096     4096
>SHAREDMEMSIZE = 61440    28672
>
>
>Configuration > Drivers > Native > PARADOX
>
>BLOCK SIZE = 16384 (drop-down list)
>LEVEL = 7
>STRICTINTEGRITY = TRUE
>
>
>Configuration > System > Formats > Date
>All which are True/False should be TRUE
>MODE = 0
>SEPARATOR = /
>
>Liz
>
>
>On 25 Feb 2023 17:43, Linda wrote:
>> Thanks for quick answer.
>> 1) The error message "No more files" appears when I open a normal table
(.db
>> ) file or when I open a form (.fsl) which has a table in the data model.
>> It never happens if i do an immediate new try and just 1 of 10 times.
The
>> error box gives no more information. Perhaps it disappear again after
som
>> time.
>> 
>> 2) The opened table (.db) suddenly closes when I click on a field or try
>> to scroll and sometimes witout touching it. It happens just  after some
minutes.
>> All files are on a file server winServer 2019. I am not sure if the same
>> happens with local files. I will try it out first.
>> 
>> 


Copyright © 2004 thedbcommunity.com