Subject | openening a database for exclusive access |
---|---|
Author | leicke71 |
Post date | 2004-10-07T21:55:08Z |
hi,
i need to run an update script against a database but i want to
be sure there are no other users connected to it.
1. how can i check if there are other users connected ?
2. once i have warned the users about database shutdown,
how can i connect to the database in exclusive mode so
no one else can get a connection during the update ?
this checking and the connection will be established from a
Delphi/Kylix application using TSQLConnection
regards,
leicke
i need to run an update script against a database but i want to
be sure there are no other users connected to it.
1. how can i check if there are other users connected ?
2. once i have warned the users about database shutdown,
how can i connect to the database in exclusive mode so
no one else can get a connection during the update ?
this checking and the connection will be established from a
Delphi/Kylix application using TSQLConnection
regards,
leicke