Hi

I have a client-server application setup.  I would like to check whether there are any
remote connections before I backup the database using the server app... how can I achieve
this?

Thanks in advance.

Ravinder,

<< I have a client-server application setup.  I would like to check whether
there are any remote connections before I backup the database using the
server app... how can I achieve this? >>

Just query this table in the Configuration database:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=3&topic=49

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim

<<"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Ravinder,

<< I have a client-server application setup.  I would like to check whether
there are any remote connections before I backup the database using the
server app... how can I achieve this? >>

Just query this table in the Configuration database:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=3&topic=49

--
Tim Young
Elevate Software
www.elevatesoft.com >>

How can I do this using a TEDBQuery component within my app? How do I get it to look at
the configuration database? Your manual is missing this example on page 92...

Cheers

Ravinder,

<< How can I do this using a TEDBQuery component within my app? How do I get
it to look at the configuration database? Your manual is missing this
example on page 92... >>

Just set the DatabaseName property to 'Configuration'.   The Configuration
database is just like any other database apart from the fact that it is
read-only.

--
Tim Young
Elevate Software
www.elevatesoft.com