get ip address

[jazzmaster111]

Hi:

How can I get the client's ip address?

Thanks!!

 

[NoCoolHandle]

Where you are sitting?
or a client calling a server object over the network from the server?
From Sqlserver?

 

[Borvik]

Here's a little function I use for getting the local IP.

    Public Function LocalIP() As String
        Dim h As System.Net.IPHostEntry = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName)
        Return CType(h.AddressList.GetValue(0), Net.IPAddress).ToString
    End Function

And here's one to find the Remote IP:

    Public Function RemoteHostIP(ByVal _Client As Socket) As String
        Dim iEP As IPEndPoint = _Client.RemoteEndPoint
        Return iEP.Address.ToString
    End Function