As far as Paradox 5 is being used, the answer is YES!
You can Load several simultaneous instances of Paradox on one PC (up to 9, I think) that while using the same BDE (IDAPI), work
with individual copies of CFG file.
Icon for "Pdox1" instance has:
"C:\PW5\PDOXWIN.EXE -o C:\IDAPI\IDAPI01.CFG -p C:\PRIV\PRIV01" in the command line,
icon for "Pdox2" has:
"C:\PW5\PDOXWIN.EXE -o C:\IDAPI\IDAPI02.CFG -p C:\PRIV\PRIV02" , etc.
(Please note that PRIVATE directory must be unique for each session)
I am afraid, that's NOT what you need in you case...
When you share a physical Paradox database, all users will have to read and write to the same PDOXUSRS.NET file.
So the safest way is to have the ONLY ONE copy of IDAPI.CFG file in the shared area (WAN) and make sure that it points
to ONLY ONE PDOXUSRS.NET file. The network traffic related to reading a copy of IDAPI file (once per session) and updating NET and
LCK files is NILL compared to the traffic caused by Paradox being non-client/server DB.
Usual problems are related to the situation when you try to initialize IDAPI without having access to the PDOXUSRS.NET file
(network is down or slow, etc.) The NET file would be created on the first available drive (usually C:\) and that file would start
interfering with other user's locks (*.LCK files).
So, if you can find a way to prevent users from starting (or using) Paradox when the WAN is not available (or Lock timeout is
reached), everything should be OK.
Hope this helps,
>We are connecting our five sites in a WAN. Each Site has its own databases
>and idapi file. In some cases we will to access databases over the WAN. The
>problem is we cannot access the file because another Idapi file has a lock
>Also there would never (well at least not at this time) have situation where
>need to access both local and Wan files at the same time.
>I'm use P5 but plan to upgrade to P9 with in 6 months
>So what is the best solution? I've though of a few but have not tested
>1. I Could Use a global Atapi, but I don't know how much traffic
>that would create on the expensive WAN lines. Does Pdox read the Idapi
>and put it in cache or does it constantly refer it.
>2. Some one told me that the was a command line option to tell pdox which
>file to use and I could place two icons on the desktop for each idapi file.
>If this is true does anyone know it?
>3. The third option is replication, but this has some Big disadvantages in