Article View: borland.public.delphi.database
Article #2072pdoxusrs file / multi user access / local share
From: Marcel Brugmans
Date: Mon, 02 Nov 1998 00:00
Date: Mon, 02 Nov 1998 00:00
41 lines
2025 bytes
2025 bytes
D3 app. Runs flawlessly. Uses BDE 4 and Paradox tables with referential integrity. I want to allow extra user(s) to use the application via peer-to-peer Win95/98 network. I have tried 3 different scenarios: --ONE (the usual setting which works fine with Delphi apps using dBASE files) Setting: No special settings or coding. Result: Users can use app and access tables without problem. But, only the changes of one user are stored! --TWO (as advised by Paradox 8 readme) Setting: "LOCAL SHARE" to TRUE in the BDE Configuration Utility on the System page. Results: The second user trying to run the app gets no access: Error message: "Directory controlled by .NET file." Location of Lock files: PDOXUSRS.NET in local root. PARADOX.LCK in app working directory. PDOXUSRS.LCK in app working directory. Note: It does not matter whether the user working on the PC that acts as the server also has LOCAL SHARE set to true. --THREE Setting: Coding in Delphi to force the LCK directory to be local: Session.PrivateDir to local directory. Result: As in scenario TWO except the location of the lock files is different. Location of Lock files: PDOXUSRS.NET in local root. PARADOX.LCK in local root. PDOXUSRS.LCK in local root. PDOXUSRS.LCK in app working directory. Anyone any idea how to allow multiple access? Marcel Brugmans
Technical Details
Message-ID:
<MPG.10a7de1ffa55e889989688@news.euronet.nl>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ffff5,d416dcb13d72fe69,start X-Google-Attributes: gidffff5,public X-Google-Thread: ff75c,d416dcb13d72fe69,start X-Google-Attributes: gidff75c,public X-Google-Thread: 115d96,d416dcb13d72fe69,start X-Google-Attributes: gid115d96,public From: marcel@wordfactory.nl (Marcel Brugmans) Subject: pdoxusrs file / multi user access / local share Date: 1998/11/02 Message-ID: <MPG.10a7de1ffa55e889989688@news.euronet.nl> X-Deja-AN: 407559004 Organization: WordFactory bv Newsgroups: borland.public.delphi.database,borland.public.delphi.database.desktop,comp.lang.pascal.delphi.databases