Article View: comp.lang.pascal.delphi.databases
Article #68Re: Problem with PDOXUSRS.LCK
From: W. Prinzjakowitsch
Date: Fri, 21 Aug 1998 00:00
Date: Fri, 21 Aug 1998 00:00
154 lines
5817 bytes
5817 bytes
First it is not a logfile but a lockfile. Paradox uses this file to maintain
information who uses (and locks) which table. Borland wrote some TIs about this
and it would be better for you to read them than to read my explanation :-)
the address would be
http://www.inprise.com/devsupport/bde/ti_list/
I myself have not succeeded completely in mastering the subject. What bothers
me is the 'network initialization failure' which is connected with is connected
to PDOXUSERS.LCK and PDOXUSERS.NET too. Good luck!
In article <35DC5CAA.DAB7E649@metronet.de>, carsten.baeumchen@metronet.de
says...
>
>
>--------------800E261F3D98ACBCF7900DC7
>Content-Type: text/plain; charset=iso-8859-1
>Content-Transfer-Encoding: 8bit
>
>Hello.
>
>hope you will find some time to give some advices to the following
>problem.
>
>-Delphi 3.0 (none C/S)
>-Paradox
>-SQL
>
>I developed an application that executes hundereds of SQL statements and
>stores the results to a locale table.
>For that only one TQuery is used.
>The structure is something like that :
>
>Query.Perpare;
>Query.SQL.clear;
>Query.SQL.add ("the statement")
>Query.Open;
>"do something with the result table"
>Query.Close;
>Query.Unperpare;
>
>
>When the program is launched the log file (PDOXUSRS.LCK) will be
>created. When the procedere starts this file grows larger and larger
>until an ecception occurs : (in German "Sperrdatei zu gro�") which means
>about "Log file to large".
>The problem in fact is that the log file will not be erased or be
>shorten after closing one query so that the ecception does not occure.
>On single stand alone computer the program works beautifully. Using it
>within the network (NT) the trouble comes up. I have checked the
>diskspace, etc of the server but everything is OK.
>The program was allways started form workstations.
>
>So my question is whether this is a known problem and how to solve it.
>
>--
>Best regards
>Mit freundlichen Gr��en
>
>Carsten B�umchen
>================
>http://www.Bundesligaverwaltung.home.pages.de
>http://www.MDIPanel.home.pages.de
>carsten.baeumchen@metronet.de
>================
>Neuss, Germany
>
>
>--
>Best regards
>Mit freundlichen Gr��en
>
>Carsten B�umchen
>================
>http://www.Bundesligaverwaltung.home.pages.de
>http://www.MDIPanel.home.pages.de
>carsten.baeumchen@metronet.de
>================
>Neuss, Germany
>
>
>--------------800E261F3D98ACBCF7900DC7
>Content-Type: text/html; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
><HTML>
>Hello.
>
><P>hope you will find some time to give some advices to the following problem.
>
><P>-Delphi 3.0 (none C/S)
><BR>-Paradox
><BR>-SQL
>
><P>I developed an application that executes hundereds of SQL statements
>and stores the results to a locale table.
><BR>For that only one TQuery is used.
><BR>The structure is something like that :
>
><P>Query.Perpare;
><BR>Query.SQL.clear;
><BR>Query.SQL.add ("the statement")
><BR>Query.Open;
><BR>"do something with the result table"
><BR><B></B>Query.Close;
><BR>Query.Unperpare;
><BR>
>
><P>When the program is launched the log file (PDOXUSRS.LCK) will be created.
>When the procedere starts this file grows larger and larger until an ecception
>occurs : (in German "Sperrdatei zu groß") which means about "Log
>file to large".
><BR>The problem in fact is that the log file will not be erased or be shorten
>after closing one query so that the ecception does not occure.
><BR>On single stand alone computer the program works beautifully. Using
>it within the network (NT) the trouble comes up. I have checked the diskspace,
>etc of the server but everything is OK.
><BR>The program was allways started form workstations.
>
><P>So my question is whether this is a known problem and how to solve it.
>
><P>--
><BR>Best regards
><BR>Mit freundlichen Grüßen
>
><P>Carsten Bäumchen
><BR>================
><BR><A
HREF="http://www.Bundesligaverwaltung.home.pages.de">http://www.Bundesligaverwa
ltung.home.pages.de</A>
><BR><A
HREF="http://www.MDIPanel.home.pages.de">http://www.MDIPanel.home.pages.de</A>
><BR>carsten.baeumchen@metronet.de
><BR>================
><BR>Neuss, Germany
><BR>
>
><P>--
><BR>Best regards
><BR>Mit freundlichen Grüßen
>
><P>Carsten Bäumchen
><BR>================
><BR><A
HREF="http://www.Bundesligaverwaltung.home.pages.de">http://www.Bundesligaverwa
ltung.home.pages.de</A>
><BR><A
HREF="http://www.MDIPanel.home.pages.de">http://www.MDIPanel.home.pages.de</A>
><BR>carsten.baeumchen@metronet.de
><BR>================
><BR>Neuss, Germany
><BR> </HTML>
>
>--------------800E261F3D98ACBCF7900DC7--
>
Technical Details
Message-ID:
<6rjqi3$l0c$7@www.univie.ac.at>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35DC5CAA.DAB7E649@metronet.de>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: ffff5,be1e2c4f3b414b8d X-Google-Attributes: gidffff5,public X-Google-Thread: ff75c,be1e2c4f3b414b8d X-Google-Attributes: gidff75c,public X-Google-Thread: f6386,be1e2c4f3b414b8d X-Google-Attributes: gidf6386,public X-Google-Thread: 10de66,be1e2c4f3b414b8d X-Google-Attributes: gid10de66,public From: wolfgang.prinzjakowitsch@univie.ac.at (W. Prinzjakowitsch) Subject: Re: Problem with PDOXUSRS.LCK Date: 1998/08/21 Message-ID: <6rjqi3$l0c$7@www.univie.ac.at> X-Deja-AN: 383319617 References: <35DC5CAA.DAB7E649@metronet.de> Content-Type: Text/Plain; charset=ISO-8859-1 X-Complaints-To: news-adm@news.univie.ac.at X-Trace: www.univie.ac.at 903703939 21516 131.130.104.39 (21 Aug 1998 12:52:19 GMT) Organization: University of Vienna Mime-Version: 1.0 NNTP-Posting-Date: 21 Aug 1998 12:52:19 GMT Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers,borland.public.delphi.database.desktop,borland.public.delphi.database.multi-tier