Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Determining current database connections? |
Sat, Mar 14 2009 1:08 PM | Permanent Link |
"Hedley Muscroft" | 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! |
Sat, Mar 14 2009 1:42 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Hedley
Only by monitoring it yourself. Have a look in the extensions ng for a contribution by Terry Swiers - EDB User Count Roy Lambert |
Sat, Mar 14 2009 1:59 PM | Permanent Link |
"Hedley Muscroft" | 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? |
Sat, Mar 14 2009 2:15 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
This web page was last updated on Friday, April 26, 2024 at 06:09 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |