Board index » delphi » pdoxusrs.lck and pdoxusrs.net files

pdoxusrs.lck and pdoxusrs.net files

When you use Paradox tables lock files are created in two locations.

1) The directories that contain tables you are accessing.
2) Your private directory.

By default the private directory is set to your startup directory.

--
Bill

(TeamB cannot answer questions received via email.)
(To contact me for any other reason remove nospam from my address)

 

Re:pdoxusrs.lck and pdoxusrs.net files


Quote
>    My questions are:
>    1- How that lock file got there?

BDE creates it

Quote
>    2- Why the program makes use of the lock file in its directory if
>the databases are not in that directory.

BDE uses paradox tables for the temporary tables it creates.  sounds like you
are having problems iwth the directory used as the Private directory.

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Re:pdoxusrs.lck and pdoxusrs.net files


http://www.inprise.com/devsupport/bde/ti_list/TI2817.html
Maybe you will find some information at this site..

Remeber using paradox you must set  Local share to TRUE in your BDE.
You should have a Net dir.  (not your root c:)  f.eks.   c:\net ,
and you must set up a privat dir. for your app, where your lockfile will be
kept
as long as your app is running. Your lockfile will be deletet when your app.
is
closing. If your system crash , you will need to delete the lock files
before you can
start your app. again..

This information below is copied from a news ...................  Maybe some
more information ....
********************************************************
  This problem is specific to Paradox tables and can be caused in any BDE
(16 or 32 Bit) application that meet
   some or all of the following criteria:
                            1.The Executable is in the same directory as the
table.
                            2.The Private Directory is not correctly set or
not set at all.
                            3.Delphi: Having a TTable open on a paradox
table and then performing multiple TQuery operations.
                            4.C / C++: Having a table open with DbiOpenTable
and then performing multiple queries with DbiQExec
                              and/or DbiQExecDirect.
                            5.LOCAL SHARE set to true in the BDE
Configuration Utility on the System page.

                         To solve the problem, make sure that your
application has done ALL of the following:

                            1.Under the directory where the executable is,
create three new directories: TABLES, PRIV, and NET.
                              Place all the tables for the application into
the TABLES directory.
                            2.Set the session's private directory to the
PRIV directory. Take the following steps according to the
                              software you are using.

                              DELPHI:
                              Session.PrivateDir :=
ExtractFilePath(ParamStr(0)) + 'PRIV';

                              C / C++:
                              DbiSetPrivateDir(szPath);
                              // szPath is the fully qualified path (not
relative) to the PRIV directory.
                            3.Set the session's network directory to the NET
directory. Take the following steps according to the
                              software you are using.

                              DELPHI:
                              Session.NetFileDir :=
ExtractFilePath(ParamStr(0)) + 'NET';

                              C / C++:
                              DbiSetProp(hSes, sesNETFILE, (UINT32)szPath);
                              // szPath is the fully qualified path (not
relative) to the NET directory.

                              // hSes is the current session handle. This
can be retrieved using the DBiGetCurrSession function.
                            4.If LOCAL SHARE is set to true and you are not
sharing tables between different applications at the
                              same time, change LOCAL SHARE to false.

********************************************************

Good luck....   :-)

Bernt
Nettsenteret..

Quote
Sebastian Cardenas wrote:
>     Hi everyone.

>     There are some details I don't understand with the 'pdoxusrs.lck'
> files.

>     This problem has ocurred to me:
>     - A lock file has been created in the directory where my application
> is running. THERE ARE NO PARADOX DATABASES IN THAT DIRECTORY.
>     - When I run the program it uses this lock file because I get one
> net file error. If I delete this lock file the program works.

>     My questions are:
>     1- How that lock file got there?
>     2- Why the program makes use of the lock file in its directory if
> the databases are not in that directory.

>     I also have another lock file and net file in the database directory
> because my net dir is set to the database directory. This is normal but
> not what is happening in the application directory.
>     I am using Paradox 7.0 and BDE 4.0

>     Thanks.

Other Threads