Fórum pdoxusers #167906
04/07/2003
0
tenho um sistema funcionando em uma rede com 9 computadores, no servidor é criado um arquivo pdoxusers.lck. Este arquivo a medida em que o sistema é utilizado ele vai aumentando de tamanho chegando ao ponto de 50 MB, neste momento começa aparecer mensagens de erro nos clientes, lock file is ground, ou mais ou menos isso. Neste momento todos os usuários saem do sistema e entram novamente, o arquivo neste momento é criado novamente com o tamanho de 1 kb, començando o ciclo novamente, quem puder me ajudar ficarei muito grato...
Marcos_ipatinga
Curtir tópico
+ 0
Responder
Posts
05/07/2003
Jf
Aqui vai a documentação que precisas, alguma dúvida adicional é só dizer, tb gostava de saber se resolveu o problema.
Technical documents from Inprise
Technical Information Document (TI2993) Removing ´Lock file has grown toolarge´ Error
Product: BDE
Version: All
Platform: Windows 3.1, Windows 95, Windows NT
----------------------------------------------------------------
Lock file has grown too large, Decimal:9495 Hex:2517
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:
The Executable is in the same directory as the table.
The Private Directory is not correctly set or not set at all.
Delphi: Having a TTable open on a paradox table and then performing multiple TQuery operations.
C / C++: Having a table open with DbiOpenTable and then performing multiple queries with DbiQExec and/or DbiQExecDirect.
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:
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.
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.
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.
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.
The above steps will correct the Lock File Too Large error.
Technical documents from Inprise
Technical Information Document (TI2993) Removing ´Lock file has grown toolarge´ Error
Product: BDE
Version: All
Platform: Windows 3.1, Windows 95, Windows NT
----------------------------------------------------------------
Lock file has grown too large, Decimal:9495 Hex:2517
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:
The Executable is in the same directory as the table.
The Private Directory is not correctly set or not set at all.
Delphi: Having a TTable open on a paradox table and then performing multiple TQuery operations.
C / C++: Having a table open with DbiOpenTable and then performing multiple queries with DbiQExec and/or DbiQExecDirect.
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:
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.
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.
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.
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.
The above steps will correct the Lock File Too Large error.
Responder
Gostei + 0
11/07/2003
Marcos_ipatinga
peguei a documentação mas ainda nao tive tempo para ir ao meu cliente para ver no que dá, mas assim que tiver resposta comunicarei com voce.
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)