when user login will had a record of from which pc name and ip address
and when user logout when delete it.

----- Original Message -----
From: "Adam" <s3057043@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, April 05, 2006 7:38 AM
Subject: [SPAM] [firebird-support] Re: Fire Bird Database connection issues.


> > The reason is I don't want total user pass from a program
> > it will not be correct example improple shutdown or
> > etc the total user still will remains.
> >
> > What one want is how many connections from client
> > connect to fire bird with from which pc name and ip address.
>
> And what I have tried to explain is that this information can not be
> read through Firebird unless you pass it in.
>
> You did not state that you were after some sort of connection limit.
> All you stated was that you wanted to know the current IP address and
> computer name. The only way Firebird will return that to you is if you
> store it against the current_connection in a table somewhere.
>
> You are going to have to maintain your own keep-alive mechanism for
> crashes clients (which should hopefully be rare).
>
> Adam
>
>
> >
> > --- In firebird-support@yahoogroups.com, "Adam" <s3057043@> wrote:
> > >
> > > > FireBird 1.5 Super Server version, Delphi 7.
> > > > I try to use Delphi "Interbase" components TIBDatabase.Usernames
> > > > but only can get user name.
> > > >
> > > > Because we need to know total users connected to server
> > > > and from which pc and ip address.
> > >
> > > You will need to insert this information into a table from your
> > > program when someone 'logs in'. There are reasonably simple windows
> > > calls for this information, and lots of sample Delphi functions.
> > >
> > > > Is it possible to e.g dll to write the function to get
> > > > local pc name and ip address and use user define function
> > > > to call this dll.
> > >
> > > Well you could write a UDF to get the PC Name and IP Address, but
> > this
> > > will be executed on the database server and so will contain
> > > information about the DATABASE SERVER. You don't want information
> > > about the server, you want information about the clients.
> > >
> > > > When everytime got user login a trigger
> > > > to write this information to a table or variable.
> > >
> > > There is no trigger on a connection, but there is also nothing
> > > stopping you from passing in this information from the login screen.
> > >
> > > Adam
> > >
> >
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>