Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Remote Record Unlocking!
Wed, May 9 2007 5:50 PMPermanent Link

Mark C.
v4.25b4 Delphi7 - Just getting back into DBISAM after a 3 year gap, bit rusty.
Using: Pessimistic Locking

*Important to note - I can only access the SERVER PC through the admin software. So i cannot delete any files directly (like .lck file) or stop any processes, so no windows
remote access

PROBLEM
Was doing some REMOTE record lock testing (2 pc's from office 1 acting as clients, connecting to SERVER at office 2).
I crashed one of the Client Pc's, it was not able to finish it's post.

Now that particular record is not editable it is permanently locked (error 10258). I understand this has nothing todo with dbisam.lck as this is table level locking. All other
records within table are editable.

I have closed all the client PC's down, I have connected to the remote server and shut that down and restarted (using the dbadmin) BUT no joy!

How can I remove this record lock???

Do I have to have remote access to the servers file system to remove some lock files or remove a process, theres no problem having this but I wanted to try and be self
sufficent and support the application using only the server admin application.
I would think this is a common thing for supporting remote applications.

Regards
Mark C.
Thu, May 10 2007 1:29 AMPermanent Link

"Ralf Bieber"
Mark C. wrote:

He Marc

>
> How can I remove this record lock???

DBIsam comes with the utility srvadmin.exe. If you connect with this to
the DBIsam-Server, you can see the client sessions list. If you remove
the crashed disconnected session the record lock is gone.

Ralf
Thu, May 10 2007 6:36 AMPermanent Link

Mark C
Thanks Ralf, I thought I was doing that by using disconnect & shutdown remotely using the SRVADMIN, but it still hung around. After using REMOVE, it was back to being unlocked. Which is
great as I can still remotley support the appplication without having direct server access.
Image