Solved

Connected to database

Posted on 2001-07-07
2
136 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: 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
Delphi Spellcheck in Webbrowser 1 74
Help on project with Soap 10 67
Making delphi communicate with a c# service 16 137
tvirtualstringtree freeze when load too manny images 10 89
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…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
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…

738 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