Solved

Connected to database

Posted on 2001-07-07
2
132 Views
Last Modified: 2010-04-06
Hi
I have a path to a interbase database, is there a way to determine if somebody is connected to the database?
0
Comment
Question by:koger
2 Comments
 
LVL 44

Expert Comment

by:CrazyOne
ID: 6261629
Well here is the way I do it.

var
 iFileHndl: Integer;

begin

iFileHndl := FileOpen('ThePath\File', fmShareExclusive or fmOpenReadWrite);
if iFileHndl < 1 then
     ShowMessage('File is already opened');

end;


The Crazy One
0
 
LVL 9

Accepted Solution

by:
ITugay earned 100 total points
ID: 6262295
Hi koger,

TIBDatabaseInfo component.


TIBDatabaseInfo.UserNames
Returns the names of all users currently attached to the database.

property UserNames: TStringList;

Description

Use UserNames to return the names of all users currently attached to the database.

-----
Igor.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question