 "No more files" error
|
"No more files" error in Paradox Tables topic (part of our Corel Paradox / ObjectPAL Coding group).
Quick Search:
"No more
"No more files"
|
|
|
|
Allan.P
|
|
Upgraded a win 7 box to win 10.
Using a win 7 client. Now recieve the error:
Cannot open: :dbx:table.db
No More files.
Table: table.db
Table: \\earth\database\xxx
Happens both manually and programatically. Can usually get it to work if I quickly try to access same table/query again. The longer I wait before retrying the greater the chance it will error again.
I see some similar issues online after Win 10 updates.
Do we have a fix?
|
| About Allan.P |
|
Approved member.
Member subscribes to this thread with a verified email.
Post ID #17784, 8 replies
Thread Started 12/31/2019 7:21:52 AM
View Counter=904
Last Reply Posted 1/21/2020 10:34:43 AM)
|
|
|
|
Location=-- --
|
|
| |
|
|
| Moderator |
|
Steven.G
|
|
over the past year, I've seen a number of weird file-access errors on Win10.. I haven't seen this particular one, but it fits the pattern
no real fix, other than a beboot, and the next win10 update.. scary stuff
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17785 (Level 2)
and Parent is 17784
Reply Posted 12/31/2019 8:12:28 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
|
|
|
Allan.P
|
|
Thinking a few options.
- Host Paradox DB on a Linux server
- Host DB on a dedicated NAS drive
- Port DB to MySQL (not even sure MySQL will work with pdox now)
I need to insulate this db against Microsoft updates.
Whatcha think?
|
| About Allan.P |
|
Approved member.
Member subscribes to this thread with a verified email.
Post ID #17790 (Level 3)
and Parent is 17784
Reply Posted 1/3/2020 10:31:33 AM
|
|
|
|
Location=-- --
|
|
| |
|
|
|
rum
|
|
Is the database currently hosted on the local win 10 computer? Or a windows server? (What OS?)
|
| About rum |
|
Membership pending.
Member subscribes to this thread with a verified email.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17792 (Level 4)
and Parent is 17784
Reply Posted 1/3/2020 11:18:01 AM
|
|
|
|
Location=Frankfort, KY USA
|
|
 |
|
|
|
Allan.P
|
|
On a win 10 box, just peer to peer.
Clients are win 7/10.
|
| About Allan.P |
|
Approved member.
Member subscribes to this thread with a verified email.
Post ID #17793 (Level 1.1)
Reply to 17792
and Parent is 17784
Thread Started 1/3/2020 11:35:01 AM
|
|
|
|
Location=-- --
|
|
| |
|
|
|
rum
|
|
What version of Paradox?
I had a very similar issue on Ver 8. (Before Win 10 killed it) The issue was related to the BDE Version that was running (which is really related to the SMB protocol that is being run under the covers, so you might look into that on the Win 10 server). Anyway, The pre-installed BDE version(contained in the PDOX 8 install) worked forever, then I started seeing the error pop up. There were some tables that would open, others that just flat refused. My issue was usually tied to the installation of a new server (Small Business 212, for one)
After installing BDE 5.2, the problem went away.
Let me know if you want to try BDE 5.2, I can probably scrounge up a url for the download.
|
| About rum |
|
Membership pending.
Member subscribes to this thread with a verified email.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17798 (Level 5)
and Parent is 17784
Reply Posted 1/3/2020 8:18:57 PM
|
|
|
|
Location=Frankfort, KY USA
|
|
|
|
|
|
Allan.P
|
|
Pdox 11 BDE 5.2
On the interesting side I did get MySQL working on server and pdox client. However a conversion to SQL does not excite me.
I am thinking linux box/NAS.
|
| About Allan.P |
|
Approved member.
Member subscribes to this thread with a verified email.
Post ID #17801 (Level 1.1)
Reply to 17798
and Parent is 17784
Thread Started 1/4/2020 9:14:20 AM
|
|
|
|
Location=-- --
|
|
| |
|
|
|
Allan.P
|
|
Re: Paradox/BDE No More Files error.
I have tried a workaround with some success.
Do a loop testing IsTable(tableName) before trying to open the table/query.
I will post the code later after more testing, but it seems to be working.
|
| About Allan.P |
|
Approved member.
Member subscribes to this thread with a verified email.
Post ID #17825 (Level 6)
and Parent is 17784
Reply Posted 1/21/2020 10:27:58 AM
|
|
|
|
Location=-- --
|
|
| |
Most Recent Post
|
|
| Moderator |
|
|
Steven.G
|
|
isTable and isFile force the file buffers to flush, so that makes sense.. and really can help as a warning here, if you're getting "false" returns, when you know you shouldn't be
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17826 (Level 7)
and Parent is 17784
Reply Posted 1/21/2020 10:32:31 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
|
