Function to retrieve domain name for an IP address?

Does anyone know of a way to do a reverse DNS lookup in MS-Access? I
have a table containing a list of IP addresses, and I want to display
the domain name for each address.

I've seen some stuff for IIS/ASP, but we don't run IIS, so I'm looking
for a (hopefully free) solution that will run standalone in MS-Access.

TIA for any advice
Ian

re: Function to retrieve domain name for an IP address?

Randy Birch has sample code to obtain the host name from an IP address at
http://www.mvps.org/vbnet/code/netwo...namefromip.htm

(Note: Randy's site is aimed at VB programmers, so sometimes the code won't
port cleanly into Access due to differences between the two. This particular
example looks as though there shouldn't be any issues, though.)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"ITM" <itm@manning.uk.com> wrote in message
news:al8dpvkkba7kecke51jds3d6d15hlh7k32@4ax.com...[color=blue]
> Does anyone know of a way to do a reverse DNS lookup in MS-Access? I
> have a table containing a list of IP addresses, and I want to display
> the domain name for each address.
>
> I've seen some stuff for IIS/ASP, but we don't run IIS, so I'm looking
> for a (hopefully free) solution that will run standalone in MS-Access.
>
> TIA for any advice
> Ian[/color]

re: Function to retrieve domain name for an IP address?

ITM <itm@manning.uk.com> wrote in message news:<al8dpvkkba7kecke51jds3d6d15hlh7k32@4ax.com>. ..[color=blue]
> Does anyone know of a way to do a reverse DNS lookup in MS-Access? I
> have a table containing a list of IP addresses, and I want to display
> the domain name for each address.
>
> I've seen some stuff for IIS/ASP, but we don't run IIS, so I'm looking
> for a (hopefully free) solution that will run standalone in MS-Access.
>
> TIA for any advice
> Ian[/color]

http://www.mvps.org/vbnet/
How to Obtain the Host Name from an IP Address

You have to look up the article... that's the title, though.

re: Function to retrieve domain name for an IP address?

Many thanks for that - exactly what I was looking for!

Ian

On 22 Oct 2003 14:25:25 -0700, pietlinden@hotmail.com (Pieter Linden)
wrote:
[color=blue]
>ITM <itm@manning.uk.com> wrote in message news:<al8dpvkkba7kecke51jds3d6d15hlh7k32@4ax.com>. ..[color=green]
>> Does anyone know of a way to do a reverse DNS lookup in MS-Access? I
>> have a table containing a list of IP addresses, and I want to display
>> the domain name for each address.
>>
>> I've seen some stuff for IIS/ASP, but we don't run IIS, so I'm looking
>> for a (hopefully free) solution that will run standalone in MS-Access.
>>
>> TIA for any advice
>> Ian[/color]
>
>http://www.mvps.org/vbnet/
>How to Obtain the Host Name from an IP Address
>
>You have to look up the article... that's the title, though.[/color]