Is there any way of determining if there are any users currently connected
to an EDB database when it's working in file-based mode (not C/S)?

Ideally I'd like to know who is connected at any time (ip address/EDB role
name), but my guess is that would only be possible running in C/S mode.

I'm hoping that as all users must go through the same EDBConfig.EDBCfg file,
there is at least a way of determining if anyone else is using the database
at any given point?

Many thanks!

Hedley


Only by monitoring it yourself. Have a look in the extensions ng for a contribution by Terry Swiers - EDB User Count

Roy Lambert

Thanks Roy. Unfortunately I'm using the ADO.NET providers in C# so I doubt I
can incorporate a Delphi extension easily.

What about the EDBConfig.EDBLck file?

If I make sure that I am not connected to the database myself (i.e. that my
connections are closed) and then I check for the existence of that file, or
perhaps try to rename it, would that tell me accurately whether the database
was in use elsewhere?

Hedley

>What about the EDBConfig.EDBLck file?
>
>If I make sure that I am not connected to the database myself (i.e. that my
>connections are closed) and then I check for the existence of that file, or
>perhaps try to rename it, would that tell me accurately whether the database
>was in use elsewhere?

Not unless Tim is keeping secrets He's been asked about this a few times and the answer is role your own.

>Thanks Roy. Unfortunately I'm using the ADO.NET providers in C# so I doubt I
>can incorporate a Delphi extension easily.

If you do please post it to the extensions.

Roy Lambert [Team Elevate]