Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
Microsoft open files |
Tue, Mar 13 2007 2:14 AM | Permanent Link |
"Al Vas" | Hi,
Had a peculiar incident today and just wanted to clarify for my own mind. In client/server mode, clients network appears to have had a hiccup. Our app had a few issues on workstations after that so I went in to sysadmin and disconnected then removed all sessions, stopped and restarted the dbisam engine and then logged a user back in. They received an error about a file being locked, so logged them off and investigated. Looking in Microsoft shares, I found that a number of DBISAM files were open. My question is should this be possible if you disconnect and remove all sessions and then restart the database engine? If so what other options are there other than waiting for a timeout or individually one by one closing the files from with Microsft's manager? Thanks Alex |
Tue, Mar 13 2007 6:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Alex,
<< In client/server mode, clients network appears to have had a hiccup. Our app had a few issues on workstations after that so I went in to sysadmin and disconnected then removed all sessions, stopped and restarted the dbisam engine and then logged a user back in. They received an error about a file being locked, so logged them off and investigated. Looking in Microsoft shares, I found that a number of DBISAM files were open. My question is should this be possible if you disconnect and remove all sessions and then restart the database engine? >> The only way locks show up in the resources listing for users is if they are accessing the tables directly, not via C/S. Did you verify that all users are connecting via C/S and not via direct access ? A good way to lock that down is to simply make sure that none of the users have the proper rights to access any of the files in the database directory directly. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |