Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 3 of 3 total |
Remote Record Unlocking! |
Wed, May 9 2007 5:50 PM | Permanent 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 AM | Permanent 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 AM | Permanent 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. |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |