Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Get Clients IP adress


This question is answered.


Permlink Replies: 3 - Last Post: Aug 9, 2017 10:00 AM Last Post By: Jeff Overcash (...
Melissa Torn

Posts: 143
Registered: 4/30/09
Get Clients IP adress  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 8, 2017 6:04 AM
Is that possible to get all connected clients IP adresses
in Interbase 2007 ?

Thank You
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Get Clients IP adress  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 8, 2017 10:15 AM   in response to: Melissa Torn in response to: Melissa Torn
Melissa Torn wrote:
Is that possible to get all connected clients IP adresses
in Interbase 2007 ?

Thank You

Query tmp$attachments. The clients host, ipaddress and even the PID of hte
process is available there.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Melissa Torn

Posts: 143
Registered: 4/30/09
Re: Get Clients IP adress  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 9, 2017 2:24 AM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Thank you so much Jeff,
When i query SELECT * FROM TEMP$ATTACHMENTS
in IBCONSOLE i can see all details of connected users
but when i make a form in Delphi and query via SQLDataset i get
an EMPTY result ( query works but result is empty )
p.s : ( I use SQLDataset+DSProvider+CDS+DataSource +DBGrid)

Thank You
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Get Clients IP adress
Correct
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 9, 2017 10:00 AM   in response to: Melissa Torn in response to: Melissa Torn
Melissa Torn wrote:
Thank you so much Jeff,
When i query SELECT * FROM TEMP$ATTACHMENTS
in IBCONSOLE i can see all details of connected users
but when i make a form in Delphi and query via SQLDataset i get
an EMPTY result ( query works but result is empty )
p.s : ( I use SQLDataset+DSProvider+CDS+DataSource +DBGrid)

Thank You

it is tmp$attachments, not temp$attachments

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02