hindersaliva
asked on
SQL Server and getting client IP Address
I have an online demo of an Excel application that connects to a SQL Server via ADO and coding in VBA.
Is there a way to 'see' the client IP Address (so that I can capture it)?
Thanks
Is there a way to 'see' the client IP Address (so that I can capture it)?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Vitor, yes.
Thanks Jason. Ideally I would like to achieve this. Whenever I have an INSERT into a table I'd like to put the client IP Address of the incoming connection into a column called IPAddress. Is it possible for SQL Server to insert that as a Default Value for that column in the table design? (like GETDATE)
Thanks Jason. Ideally I would like to achieve this. Whenever I have an INSERT into a table I'd like to put the client IP Address of the incoming connection into a column called IPAddress. Is it possible for SQL Server to insert that as a Default Value for that column in the table design? (like GETDATE)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.