dbTalk Databases Forums  

Status 81 on insert and update

comp.databases.btrieve comp.databases.btrieve


Discuss Status 81 on insert and update in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Marx
 
Posts: n/a

Default Status 81 on insert and update - 05-05-2004 , 05:20 AM






Problem: data can be read from any table but every atempt to wirte into
database causes status 81. Files are not locked, user hat all rights on
directory and files, including admin rights. Installation of Btrieve seems
to ok, since working on a local drive doesn't make any problems at all.
Creating tables with butil -clone and loading data with butil -load works
fine. Updating a recordset in such a table just created with butil from
within the windows-app via w32mkde.exe causes status 81. App has been
working for years and is still doing it's job on a win2k workstation.

Konfiguration: old Win-App on XP-Workstation (SP1) using btrieve 6 via
w32mkde.exe, database files on Novell server 4.11, Novell client version
4.90.

Any help appreciated.
Chris



Reply With Quote
  #2  
Old   
Bill Bach
 
Posts: n/a

Default Re: Status 81 on insert and update - 05-09-2004 , 08:58 AM






The Win32 engine requires access to special 0-byte LCK files in order to
handle multi-user concurrency. Your system is likely unable to create these
LCK files for some reason, perhaps because of lack of create or delete rights
(in case the LCK file already exists).

If you use a client/server engine on the database server, not only will you
have MUCH better performance, but you'll eliminate the use of these LCK files
and resolve the problem completely. Right now, you must figure out why the
LCK files cannot be created.

There is a tool at www.sysinternals.com called FileMon that may be helpful in
this regard.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: June, 2004: See our web site for details!


Chris Marx wrote:

Quote:
Problem: data can be read from any table but every atempt to wirte into
database causes status 81. Files are not locked, user hat all rights on
directory and files, including admin rights. Installation of Btrieve seems
to ok, since working on a local drive doesn't make any problems at all.
Creating tables with butil -clone and loading data with butil -load works
fine. Updating a recordset in such a table just created with butil from
within the windows-app via w32mkde.exe causes status 81. App has been
working for years and is still doing it's job on a win2k workstation.

Konfiguration: old Win-App on XP-Workstation (SP1) using btrieve 6 via
w32mkde.exe, database files on Novell server 4.11, Novell client version
4.90.

Any help appreciated.
Chris


Reply With Quote
  #3  
Old   
Chris Marx
 
Posts: n/a

Default Re: Status 81 on insert and update - 05-10-2004 , 04:06 AM



I don't think that the LCK files are causing the problem. The check tis I
copied the database files to a new an empty directory on the server, deleted
all lck files and startetd the application. I checked the content of the
directory and saw that the lck files of all opend database files were
created by the engine.

Any more hints?
Chris

"Bill Bach" <bbach (AT) cncdsl (DOT) com> schrieb im Newsbeitrag
news:409E3917.A9896BDC (AT) cncdsl (DOT) com...
Quote:
The Win32 engine requires access to special 0-byte LCK files in order to
handle multi-user concurrency. Your system is likely unable to create
these
LCK files for some reason, perhaps because of lack of create or delete
rights
(in case the LCK file already exists).

If you use a client/server engine on the database server, not only will
you
have MUCH better performance, but you'll eliminate the use of these LCK
files
and resolve the problem completely. Right now, you must figure out why
the
LCK files cannot be created.

There is a tool at www.sysinternals.com called FileMon that may be helpful
in
this regard.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: June, 2004: See our web site for details!


Chris Marx wrote:

Problem: data can be read from any table but every atempt to wirte into
database causes status 81. Files are not locked, user hat all rights on
directory and files, including admin rights. Installation of Btrieve
seems
to ok, since working on a local drive doesn't make any problems at all.
Creating tables with butil -clone and loading data with butil -load
works
fine. Updating a recordset in such a table just created with butil from
within the windows-app via w32mkde.exe causes status 81. App has been
working for years and is still doing it's job on a win2k workstation.

Konfiguration: old Win-App on XP-Workstation (SP1) using btrieve 6 via
w32mkde.exe, database files on Novell server 4.11, Novell client version
4.90.

Any help appreciated.
Chris




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.