Board index » delphi » DOS Engine locking problems on NT

Diane Kennedy

Delphi Developer
Mon, 05 Nov 2001 03:00:00 GMT

DOS Engine locking problems on NT

I have an old Pascal DOS app that uses the Paradox Engine 3.0.  It is a
multi user application with the database files located on a shared
network file service, with the user PCs running Windows 95.

This app has been running for years on a Banyan file service. Once the
PCs were upgraded to windows 95 we began having periodic problems with
the database files locking up (once every couple of months one of the
tables would just completely freeze up), but when we moved the database
files to an NT file service last month, the problem drastically
increased.  I've got it down to once a week, or so, but the users are
really losing patience!

I've been reading about references to known compatibility problems with
Paradox locking methods and NT, but can't find specifics.  Can anyone
help with that?  Is there any advice or fixes that help with this
problem?

Please Help!

Diane

 
Bill Tod

Delphi Developer
Mon, 05 Nov 2001 03:00:00 GMT

Re:DOS Engine locking problems on NT


Disable optimistic locking on NT and see if that helps.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
 for any other reason remove nospam from my address.)

David Ree

Delphi Developer
Mon, 05 Nov 2001 03:00:00 GMT

Re:DOS Engine locking problems on NT


In addition to Bill's response...   make sure the "Disable New File Locking
Semantics" on your Win95 clients is checked - Control Panel / System /
Performance / Troubleshooting..

--
David Reed
Diamond Software Group
Oasis Rep Software, Inc
www.diamondsg.com
www.oasisrep.com

Quote
Diane Kennedy wrote in message <3744968D.63B3A...@pacbell.net>...
>I have an old Pascal DOS app that uses the Paradox Engine 3.0.  It is a
>multi user application with the database files located on a shared
>network file service, with the user PCs running Windows 95.

>This app has been running for years on a Banyan file service. Once the
>PCs were upgraded to windows 95 we began having periodic problems with
>the database files locking up (once every couple of months one of the
>tables would just completely freeze up), but when we moved the database
>files to an NT file service last month, the problem drastically
>increased.  I've got it down to once a week, or so, but the users are
>really losing patience!

>I've been reading about references to known compatibility problems with
>Paradox locking methods and NT, but can't find specifics.  Can anyone
>help with that?  Is there any advice or fixes that help with this
>problem?

>Please Help!

>Diane

Diane Kenned

Delphi Developer
Thu, 08 Nov 2001 03:00:00 GMT

Re:DOS Engine locking problems on NT


Thank you for the suggestions!

Before I go talk to the desktop support people about checking this box, can you
offer any information on what the side effects or any downside would be?  Are
my desktop support people likely to have an argument against this that I should
be prepared to answer?

Also, Bill's suggestion to "Disable optimistic locking on NT";  is this done on
the server or desktop?  Are there side effects here as well?

Thanks for your help.  It's very much appreciated!

Diane

Quote
David Reed wrote:
> In addition to Bill's response...   make sure the "Disable New File Locking
> Semantics" on your Win95 clients is checked - Control Panel / System /
> Performance / Troubleshooting..

> --
> David Reed
> Diamond Software Group
> Oasis Rep Software, Inc
> www.diamondsg.com
> www.oasisrep.com
> Diane Kennedy wrote in message <3744968D.63B3A...@pacbell.net>...
> >I have an old Pascal DOS app that uses the Paradox Engine 3.0.  It is a
> >multi user application with the database files located on a shared
> >network file service, with the user PCs running Windows 95.

> >This app has been running for years on a Banyan file service. Once the
> >PCs were upgraded to windows 95 we began having periodic problems with
> >the database files locking up (once every couple of months one of the
> >tables would just completely freeze up), but when we moved the database
> >files to an NT file service last month, the problem drastically
> >increased.  I've got it down to once a week, or so, but the users are
> >really losing patience!

> >I've been reading about references to known compatibility problems with
> >Paradox locking methods and NT, but can't find specifics.  Can anyone
> >help with that?  Is there any advice or fixes that help with this
> >problem?

> >Please Help!

> >Diane

Bill Tod

Delphi Developer
Thu, 08 Nov 2001 03:00:00 GMT

Re:DOS Engine locking problems on NT


Disabling Optimistic Locking is done on the server. Some servers seem to
require this and some do not. I have never seen an explanation of why this
is the case.

There is no real downside that I know of to disabling new file sharing and
locking symantics on Win95.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
 for any other reason remove nospam from my address.)

Maciej Hajewsk

Delphi Developer
Mon, 12 Nov 2001 03:00:00 GMT

Re:DOS Engine locking problems on NT


See Q129202 article in M$/kb
(http://support.microsoft.com/support/kb/articles/q129/2/02.asp).

Maciej Hajewski

Bill Todd napisa3(a) w wiadomo?ci: <7ia6md$p...@forums.borland.com>...

Quote
>Disabling Optimistic Locking is done on the server. Some servers seem to
>require this and some do not. I have never seen an explanation of why this
>is the case.

>There is no real downside that I know of to disabling new file sharing and
>locking symantics on Win95.

>Bill

>--

>Bill Todd - TeamB
>(TeamB cannot respond to email questions. To contact me
> for any other reason remove nospam from my address.)

Other Threads

1. BGI with NT problem: DOS box FROZEN

2. Lock problem for databases on NT : no solution ?

3. Lock problem for databases on NT : no solution ?

4. Scroll Engine for DOS

5. BDE engine locking SQL 7.0

6. BDE Engine Locking

7. Record Locking Strategy for Homegrown Database Engine

8. Access DB engine reord locks level

9. Paradox Database Engine 3.0 running in a Windows NT Network

10. BP7/DOS in Win95 DOS Box - IOResult problems