Solved

Connected to database

Posted on 2001-07-07
2
135 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Internet Explorer View Settings Question 15 122
Working with hours 3 72
enhance the following code 3 41
How to save the image in the .cds File ClientDataSet? 1 28
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

680 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