Logout network user

[Eddie]

Hello all,

We have a network about 70+ users. We run a client-server program that
need to reindex the database every night. The problem is, if any user
open the application in the client station, the database will be
locked and the reindexing job will have problem.

My question, is there any 3rd party application that run on the server
to log out network user from the server ?

We are using Win2K server and the client are either W2K prof or XP
prof.

I tried to search on the internet for weeks, some suggestion like "net
account ...", Group policy.., NetSessionDel., has been tried but none
of this work.

I have a small utility to installed in client station to shut down the
station in a preset time. We don't want to use it as we have to
install it on every system and hard to manage.

Thanks,
Eddie

 

[Jim Carlock]

Would suggest writing a database application to access
the database and in that manner you'd be able to force
anyone logged into the database to disconnect.

I believe there is a way to force a database to disconnect
any and all connected users from itself (unconditionally)
but that is going to vary based upon HOW your database
is set up.

Your question should be directed to database management
as it seems to be mostly a database engineering issue.

You can always throw something into the client scheduler
to temporarily disable the network adapter and re-enable
the adapter after a given amount of time. That will definitely
force a disconnect from the database, but again, how the
database itself reacts is going to be the main issue.

I would suggest setting the client up to not retain a connection
to the database, for instance, your client should run a make
table query to collect the information it needs and hold the
information it needs on the client side. This will get rid of the
database connection issue.

Good luck, and I hope the info provides some insight.

--
Jim Carlock
Post replies to newsgroup.

Hello all,

We have a network about 70+ users. We run a client-server program that
need to reindex the database every night. The problem is, if any user
open the application in the client station, the database will be
locked and the reindexing job will have problem.

My question, is there any 3rd party application that run on the server
to log out network user from the server ?

We are using Win2K server and the client are either W2K prof or XP
prof.

I tried to search on the internet for weeks, some suggestion like "net
account ...", Group policy.., NetSessionDel., has been tried but none
of this work.

I have a small utility to installed in client station to shut down the
station in a preset time. We don't want to use it as we have to
install it on every system and hard to manage.

Thanks,
Eddie