Table Locking and Exclusive use Foxpro 2.5

[BigGib]

I am migrating a network FoxPro 2.5 program to a Windows 10 network. There are three workstations and a server. The program will open on all desktops at the same time. When we try to go into order entry from multiple workstations, we get an Exclusive USE required message. On a single machine, it works fine. If I close the program on that machine, I can go into order entry on any other of the other work stations, but only one workstation at a time.

Any Ideas?

[Jos]

Your program worked fine before. So something has changed.
The Windows 10 network means you switched to Windows 10-64 workstations?
Have a look at the (local) environment settings before, and the drive assignments.
Perhaps config.fp? isn’t at the ‘right’ location. Eventually start vDos with logging (“…vDos.exe” /log). The generated vDos.log file could reveal what’s missing.

Jos

[BigGib]

I just can't figure out the problem here. I'm getting "file in use by another." anytime I'm going into order entry. I looked at the CONFIG.FP file, but I'm setting the FOXPROCFG FOR EACH WORKSTATION IN THE AUTOEXEC.TXT for vDos after I have mapped the network drive to F:

For example:
use F: \\SERVER\vDos
F:
cd OPPC
SET MONITOR=COLOR
SET FOXPROCFG=F:\FOXPRO\CONFIG.PC5

Any ideas? The Internet has been useless as a reference on this one.

[Jos]

It still seems something is off compared to the previous situation with NTVDM instances. What did vDos logging bring, at least "file in use by another." should be reported/clarified.

Jos

[jgoebel]

A few things come to mind, which you probably tried:
a) 'EXCLUSIVE' is on by default, so your program must set "EXCLUSIVE' to off, where?
b) Have checked that F:\FOXPRO\CONFIG.PC5 is available from the vDos command line?
c) If you start foxpro from the vDos command line what does ?SYS(2019) print? What does ?GETENV('FOXPROCFG') print?
John

[Dan Michelsen]

FoxPro uses a command to set exclusive on or off. The data table can only be used from one machine if exclusive is set on. Note that the table has to be reopened if you change the setting because the setting in effect at the time the table (dbf) was opened remains in effect until the table is closed. Example:


Set Exclusive On
Use WW_Keys

(WW_Keys will now be unavailable to the other terminals)

Set Exclusive Off  (WW_Keys will still be unavailable to the other terminals)
Use WW_Keys  (Reopening the file with the new setting will now make it available to the other work stations)

Exclusive use is required for packing or reindexing files.