BorlandTalk.com

Lee J Cook · Guest

Hi

I have an application which is installed on several workstations NT4 sp6a
and they all read and write the data to a windows 2000 server, each
workstations NET DIR is correctly pointing to the same folder on the server
using UNC my question is, does the server need the BDE installing if the
server is not being used to run my Delphi 6 application, the server is just
for the data, my application uses the BDE and paradox tables with SQL and I
have been getting a few errors regarding Blob has been modified and index
out of date errors which I have read are not programming errors but it could
be an incompatibility between NT4 and the BDE.

Also slightly more confusing, what should the LOCAL SHARE be set to for each
workstation and server if the BDE is required on the server.

Thanks

Lee

Bill Todd · Guest

The BDE is not required on the server. Make sure that the BDE on every
PC is configured exactly as described in
http://community.borland.com/article/0,1410,15247,00.html . That
includes setting Local Share to true as described in the article.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

heiko Luettge · Guest

hi,

additional to Bill :
- Disable write cache at the clients.

You also have to set some server settings, if the server is NT or higher
(w2k, xp).

in registry create some new parameters of type Typ DWORD

HKEY_LOCAL_MACHINESystemCurrentControlSetServices

LanmanServerParameters.

EnableOpLocks 0

EnableOpLockForceControl 1

CachedOpenLimit 0

UseOpportunisticLocking 0

UtilizeNtCaching 0

if the "server" is a nt workstation use LanmanWorkstation instead of
LanmanServer.

reboot server after setting.

After this settings one of my pdx app run with lesser errors ,

BUT

A paradox app has a lot of problems with NT with all settings.

There is no way to reduce the errors to 0.

With this settings the server is slower (2x) than before,

because the settings shut off some faetures of the file system.

Search for oplocks (opportunistic locks) at microsoft homepage for more
details

Heiko

PS:
I change my app to Interbase and now have 0 errors.