Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Microsoft open files
Tue, Mar 13 2007 2:14 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image