Board index » delphi » Paradox problem on the NET - problem

Paradox problem on the NET - problem

Hi,

I'm using Delphi 3.02 C/S with BDE 4.51.

I've got the following problem with Paradox:

I installed a program on a server and wanted to call it from 2 client
PCs.

The Paradox tables I use are located on the client PCs. Nevertheless I
cannot open the
tables at the same time (i.e. tables with the same name on the same
alias).
Is this caused by PDOXUSRS.LCK?

Is there a workaround?

Christian

 

Re:Paradox problem on the NET - problem


1. Set the NetFileDir to the same path on all clients. The path has to be
EXACTLY the same on ALL clients, inclusive the drive-letter!
You can set it in the BDE-Config or in the TSession-Component at runtime
2. Before the first start, delete all P*.LCK and P*.NET files.

then it should work

--
Andreas Klein
Remove XXX from my eMail

Christian Puchbauer schrieb in Nachricht <3577FBEE.1...@otob.at>...

Quote
>Hi,

>I'm using Delphi 3.02 C/S with BDE 4.51.

>I've got the following problem with Paradox:

>I installed a program on a server and wanted to call it from 2 client
>PCs.

>The Paradox tables I use are located on the client PCs. Nevertheless I
>cannot open the
>tables at the same time (i.e. tables with the same name on the same
>alias).
>Is this caused by PDOXUSRS.LCK?

>Is there a workaround?

>Christian

Re:Paradox problem on the NET - problem


Quote
Andreas Klein wrote:

> 1. Set the NetFileDir to the same path on all clients. The path has to be
> EXACTLY the same on ALL clients, inclusive the drive-letter!

False, the drive letter may be different.

C?me

Re:Paradox problem on the NET - problem


Are you sure?

Maybe its different between Peer-to-Peer and Novell-Networks.
--
Andreas Klein
Remove XXX from my eMail

Come de CHRISTEN schrieb in Nachricht <3579AD5A.3...@wanadoo.fr>...

Quote
>Andreas Klein wrote:

>> 1. Set the NetFileDir to the same path on all clients. The path has to be
>> EXACTLY the same on ALL clients, inclusive the drive-letter!

>False, the drive letter may be different.

>C?me

Re:Paradox problem on the NET - problem


Christian,

There are 2 properties in your Paradox Driver that must be configured
correctly otherwise you WILL get problems.

The first is the NETDIR - this points to the directory in which the P*.NET
and P*.LCK files get created. All users of the system must point to the same
directory. If not, each user wil have NET and LCK files created on their
local machines. If that happens then the BDE has no way of knowing what
locks are currently in place and corruptions will occur. Instead of
referrring to a Drive\Path why not use UNC naming eg.
\\MYSERVER\MYSYSTEM\DATA  - that way drive letters are not an issue.

The second property is PRIVATEDIR which is used for the creation of
temporary files. This should always be set to point to a directory on the
local machine. Each user should have their own private directory, if not
then problems can arise.

Good Luck

Campbell Fuller

Quote
Christian Puchbauer wrote in message <3577FBEE.1...@otob.at>...
>Hi,

>I'm using Delphi 3.02 C/S with BDE 4.51.

>I've got the following problem with Paradox:

>I installed a program on a server and wanted to call it from 2 client
>PCs.

>The Paradox tables I use are located on the client PCs. Nevertheless I
>cannot open the
>tables at the same time (i.e. tables with the same name on the same
>alias).
>Is this caused by PDOXUSRS.LCK?

>Is there a workaround?

>Christian

Re:Paradox problem on the NET - problem


Quote
Come de CHRISTEN wrote:
> Andreas Klein wrote:

> > 1. Set the NetFileDir to the same path on all clients. The path has to be
> > EXACTLY the same on ALL clients, inclusive the drive-letter!

> False, the drive letter may be different.

This has been my experience as well, but I was on a Novel network at the time.
(It may be different if they're using different network software.)

Sarah J Straith
ObjectPAL Programmer/Database Specialist

Make mine BORLAND!!!

Re:Paradox problem on the NET - problem


Hi,

But what will happen if all users are logged in with the same userid
such as is the case with CGI programs running under IIS
(username=IUSR?????). I have big troubles sharing a directory of dBase
files with a CGI program that can be executed simultaneously by remote
users. I keep getting "Directory is busy" exceptions. I think each user
ID can only connect once and since IIS uses one userid for everybody
that's a big problem.

-Craig Manley.

Quote
Andreas Klein wrote:

> 1. Set the NetFileDir to the same path on all clients. The path has to be
> EXACTLY the same on ALL clients, inclusive the drive-letter!
> You can set it in the BDE-Config or in the TSession-Component at runtime
> 2. Before the first start, delete all P*.LCK and P*.NET files.

> then it should work

> --
> Andreas Klein
> Remove XXX from my eMail

> Christian Puchbauer schrieb in Nachricht <3577FBEE.1...@otob.at>...
> >Hi,

> >I'm using Delphi 3.02 C/S with BDE 4.51.

> >I've got the following problem with Paradox:

> >I installed a program on a server and wanted to call it from 2 client
> >PCs.

> >The Paradox tables I use are located on the client PCs. Nevertheless I
> >cannot open the
> >tables at the same time (i.e. tables with the same name on the same
> >alias).
> >Is this caused by PDOXUSRS.LCK?

> >Is there a workaround?

> >Christian

Other Threads