VBA, Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names

Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names

Author	Message
Bengt Lidgar #1 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Hi, a.. I'm developing a small app (in Excel/Access) that analyses our Web Logfiles. In particular I want to check the SiteName or Owner of visiting IP addresses. b.. I have been running NsLookup which I at first thought was an excellent solution (simple and fast). However, Nslookup isn't good enough as it can't find all the IP adresses (I tried changing the Server, but could'nt make it work....) The Whois function at www.Ripe.net looks ideal! Questions: 1.. What would be the best Newsgroup to get more input if nothing succeeds? 2.. Is there a command line Whois.exe for DOS/Win2000? (seems to exist for Unix) (many small apps exist, but I need to integrate in other code) 3.. Is there any available/freeware VB code that could also do this? I found "WhoIs ActiveX DLL" from Able Consulting d.. Is it possible to FTP to RIPE? e.. Is there any code example VBA to: Access a web page, Enter the IPaddress and Extract the ouput down to a file? 6.. Am I a looser that hasn't been able to make NsLookup perform? What would be the best server site?! Many, many thanks for any kind of input!!! Bengt
Sun, 25 Jul 2004 20:22:55 GMT

Tony Toew #2 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: >Questions: > 1.. What would be the best Newsgroup to get more input if nothing succeeds? This one or a vb group as most VB APIs work just fine in Access/Excel/Word or other app which has VBA built in. Many third party controls don't. Quote: > 2.. Is there a command line Whois.exe for DOS/Win2000? (seems to exist for Unix) (many small apps exist, but I need to integrate in other code) No idea. Quote: > 3.. Is there any available/freeware VB code that could also do this? I found "WhoIs ActiveX DLL" from Able Consulting Mabry, among others, sell a Windows socket control. There are several other vendors that also do so. See the Access Email FAQ at my website for a list of such. You could try programming against the the windows socket layer directly or via using the Winsock control. The following are some links I found when doing some TCP/IP research. Google Web Directory - Computers Programming Internet Sockets http://directory.google.com/Top/Computers/Programming/Internet/Sockets/ Windows Sockets Programming http://www.snible.org/winsock/ Visual Basic Internet Programming http://www.vbip.com/ Visual Basic Internet Programming - Tools&Technologies http://www.vbip.com/tools.asp Organising Communication with WinSocket - visual basic, vb, VBScript http://www.planet-source-code.com/xq/ASP/txtCodeId.22320/lngWId.1/qx/... 15 Seconds Creating a TCP Component in Visual Basic http://www.15seconds.com/issue/990408.htm Quote: > d.. Is it possible to FTP to RIPE? No idea. Quote: > e.. Is there any code example VBA to: Access a web page, Enter the IPaddress and Extract the ouput down to a file? No idea but again VB code might work. Try the various VB links from www.mvps.org or do a search at the Knowledge Base at support.microsoft.com or the Developers Network at msdn.microsoft.com. Quote: > 6.. Am I a looser that hasn't been able to make NsLookup perform? What would be the best server site?! Not at all. Using NsLookup in this fashion is an interesting exercise. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Thu, 29 Jul 2004 08:13:25 GMT

Alex Angelopoulo #3 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Well, Tony - he may not have replied, but I am doing some work with an IT administrator toolpad which I want to extend with more IP troubleshooting ability and your references are very handy. I've been using a lot of the server-side code sites and these are ones I don't recall hitting before. Quote: > >Questions: > > 1.. What would be the best Newsgroup to get more input if nothing succeeds? > This one or a vb group as most VB APIs work just fine in > Access/Excel/Word or other app which has VBA built in. Many third > party controls don't. > > 2.. Is there a command line Whois.exe for DOS/Win2000? (seems to exist for Unix) (many small apps exist, but I need to integrate in other code) Quote: > No idea. > > 3.. Is there any available/freeware VB code that could also do this? I found "WhoIs ActiveX DLL" from Able Consulting Quote: > Mabry, among others, sell a Windows socket control. There are > several other vendors that also do so. See the Access Email FAQ at my > website for a list of such. > You could try programming against the the windows socket layer > directly or via using the Winsock control. The following are some > links I found when doing some TCP/IP research. > Google Web Directory - Computers Programming Internet Sockets http://directory.google.com/Top/Computers/Programming/Internet/Sockets / Quote: > Windows Sockets Programming > http://www.snible.org/winsock/ > Visual Basic Internet Programming > http://www.vbip.com/ > Visual Basic Internet Programming - Tools&Technologies > http://www.vbip.com/tools.asp > Organising Communication with WinSocket - visual basic, vb, vbscript http://www.planet-source-code.com/xq/ASP/txtCodeId.22320/lngWId.1/qx/v b/scripts/ShowCode.htm Quote: > 15 Seconds Creating a TCP Component in Visual Basic > http://www.15seconds.com/issue/990408.htm > > d.. Is it possible to FTP to RIPE? > No idea. > > e.. Is there any code example VBA to: Access a web page, Enter the IPaddress and Extract the ouput down to a file? Quote: > No idea but again VB code might work. Try the various VB links from > www.mvps.org or do a search at the Knowledge Base at > support.microsoft.com or the Developers Network at msdn.microsoft.com. > > 6.. Am I a looser that hasn't been able to make NsLookup perform? What would be the best server site?! Quote: > Not at all. Using NsLookup in this fashion is an interesting > exercise. > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm
Thu, 29 Jul 2004 15:32:35 GMT

Bengt Lidgar #4 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Tony, Thank you very much for this insightful help. Seems like there isn't really any fast solution to my problem. I will need some time to digest this (and catch up to the right level). Bengt Quote: > >Questions: > > 1.. What would be the best Newsgroup to get more input if nothing succeeds? > This one or a vb group as most VB APIs work just fine in > Access/Excel/Word or other app which has VBA built in. Many third > party controls don't. > > 2.. Is there a command line Whois.exe for DOS/Win2000? (seems to exist for Unix) (many small apps exist, but I need to integrate in other code) Quote: > No idea. > > 3.. Is there any available/freeware VB code that could also do this? I found "WhoIs ActiveX DLL" from Able Consulting Quote: > Mabry, among others, sell a Windows socket control. There are > several other vendors that also do so. See the Access Email FAQ at my > website for a list of such. > You could try programming against the the windows socket layer > directly or via using the Winsock control. The following are some > links I found when doing some TCP/IP research. > Google Web Directory - Computers Programming Internet Sockets > http://directory.google.com/Top/Computers/Programming/Internet/Sockets/ > Windows Sockets Programming > http://www.snible.org/winsock/ > Visual Basic Internet Programming > http://www.vbip.com/ > Visual Basic Internet Programming - Tools&Technologies > http://www.vbip.com/tools.asp > Organising Communication with WinSocket - visual basic, vb, vbscript http://www.planet-source-code.com/xq/ASP/txtCodeId.22320/lngWId.1/qx/... pts/ShowCode.htm Quote: > 15 Seconds Creating a TCP Component in Visual Basic > http://www.15seconds.com/issue/990408.htm > > d.. Is it possible to FTP to RIPE? > No idea. > > e.. Is there any code example VBA to: Access a web page, Enter the IPaddress and Extract the ouput down to a file? Quote: > No idea but again VB code might work. Try the various VB links from > www.mvps.org or do a search at the Knowledge Base at > support.microsoft.com or the Developers Network at msdn.microsoft.com. > > 6.. Am I a looser that hasn't been able to make NsLookup perform? What would be the best server site?! - Hide quoted text - - Show quoted text - Quote: > Not at all. Using NsLookup in this fashion is an interesting > exercise. > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm
Sun, 01 Aug 2004 22:18:37 GMT

Tony Toew #5 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: >> 3.. Is there any available/freeware VB code that could also do this? I found "WhoIs ActiveX DLL" from Able Consulting >Mabry, among others, sell a Windows socket control. There are >several other vendors that also do so. See the Access Email FAQ at my >website for a list of such. That should state "Mabry, among others, sell a Windows whois control." Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Mon, 02 Aug 2004 02:51:46 GMT

Bengt Lidgar #6 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Hi Tony, I found these two fantastic sites that I am trying to marry: http://www.mvps.org/vbnet/index.html?code/network/hostnamefromip.htm and http://www.vbip.com/winsock/winsock_whois.asp At first I thought I was cooked since I only have the MS Office Suite and therefore not Winsock (?!). But the first program worked. Still can't crack using the second link. Somehow I am afraid that I need MS Winsock Control? What's that? Is it free? Can I do without it given that the first link succeeded? (I still absolutely need to access RIPE) Bengt Quote: > >Questions: > > 1.. What would be the best Newsgroup to get more input if nothing succeeds? > This one or a vb group as most VB APIs work just fine in > Access/Excel/Word or other app which has VBA built in. Many third > party controls don't. > > 2.. Is there a command line Whois.exe for DOS/Win2000? (seems to exist for Unix) (many small apps exist, but I need to integrate in other code) Quote: > No idea. > > 3.. Is there any available/freeware VB code that could also do this? I found "WhoIs ActiveX DLL" from Able Consulting Quote: > Mabry, among others, sell a Windows socket control. There are > several other vendors that also do so. See the Access Email FAQ at my > website for a list of such. > You could try programming against the the windows socket layer > directly or via using the Winsock control. The following are some > links I found when doing some TCP/IP research. > Google Web Directory - Computers Programming Internet Sockets > http://directory.google.com/Top/Computers/Programming/Internet/Sockets/ > Windows Sockets Programming > http://www.snible.org/winsock/ > Visual Basic Internet Programming > http://www.vbip.com/ > Visual Basic Internet Programming - Tools&Technologies > http://www.vbip.com/tools.asp > Organising Communication with WinSocket - visual basic, vb, vbscript http://www.planet-source-code.com/xq/ASP/txtCodeId.22320/lngWId.1/qx/... pts/ShowCode.htm Quote: > 15 Seconds Creating a TCP Component in Visual Basic > http://www.15seconds.com/issue/990408.htm > > d.. Is it possible to FTP to RIPE? > No idea. > > e.. Is there any code example VBA to: Access a web page, Enter the IPaddress and Extract the ouput down to a file? Quote: > No idea but again VB code might work. Try the various VB links from > www.mvps.org or do a search at the Knowledge Base at > support.microsoft.com or the Developers Network at msdn.microsoft.com. > > 6.. Am I a looser that hasn't been able to make NsLookup perform? What would be the best server site?! - Hide quoted text - - Show quoted text - Quote: > Not at all. Using NsLookup in this fashion is an interesting > exercise. > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm
Mon, 02 Aug 2004 04:28:08 GMT

Steve Rindsber #7 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: > At first I thought I was cooked since I only have the MS Office Suite and > therefore not Winsock (?!). But the first program worked. As I understand it, the Winsock control is a wrapper around the Winsock DLL. Randy's program (the first one) doesn't use the control, it works directly with the DLL Quote: > Still can't crack using the second link. Somehow I am afraid that I need MS > Winsock Control? What's that? Is it free? It comes with VB5 & 6 and probably others, but I'm not sure what else includes it.
Mon, 02 Aug 2004 22:58:53 GMT

Tony Toew #8 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: >It comes with VB5 & 6 and probably others, but I'm not sure what else >includes it. And with the ODE/MOD but not with the Pro version of Access. And given all those OCX version problems I'm going to be closely looking at going straight API calls or a third party winsock control instead of Microsofts. Tony
Thu, 05 Aug 2004 13:57:45 GMT

Steve Rindsber #9 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: > And with the ODE/MOD but not with the Pro version of Access. And given > all those OCX version problems I'm going to be closely looking at > going straight API calls or a third party winsock control instead of > Microsofts. Can't blame you there. There's always info on this stuff in the VB internet/controls sections. SocketWrench has a free Winsock control, I think. Their stuff seems well documented also. If you can find API code to do the job that'd be best, IMO. So many of these controls are handy but require you to ship a meg worth of MFC dependency bits and bobs. Foo. Doesn't Dev Ashish have a site off the mvps.org site? Check his place. I wouldn't be surprised if he had just the thing.
Fri, 06 Aug 2004 05:21:57 GMT

Tony Toew #10 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: >> And with the ODE/MOD but not with the Pro version of Access. And given >> all those OCX version problems I'm going to be closely looking at >> going straight API calls or a third party winsock control instead of >> Microsofts. >Can't blame you there. There's always info on this stuff in the VB >internet/controls sections. SocketWrench has a free Winsock control, I >think. Their stuff seems well documented also. I've purchased the Mabry controls a while back and the SMTP, POP3 and RAS controls worked quite well. Quote: >If you can find API code to do the job that'd be best, IMO. So many of >these controls are handy but require you to ship a meg worth of MFC >dependency bits and bobs. Foo. Ayup. Quote: >Doesn't Dev Ashish have a site off the mvps.org site? Check his place. I >wouldn't be surprised if he had just the thing. I don't recall any API Winsock stuff there. I think this'd be {filter} enough that not even too many VBers would play with it. Peter Walker is mentioning experimenting with some in another thread with Winsock in the title. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.--*.com/
Fri, 06 Aug 2004 14:42:00 GMT

Steve Rindsber #11 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: > I've purchased the Mabry controls a while back and the SMTP, POP3 and > RAS controls worked quite well. Their sample RAS code has a few holes in it - it makes a lot of potentially invalid assumptions about NT phonebooks, but it handles the default situation well. We pointed this out, sent improved code, they never put it up on the site, o well. No problem with the control itself, mind, just with the sample code. Quote: > I don't recall any API Winsock stuff there. I think this'd be {filter} > enough that not even too many VBers would play with it. You're probably right. I just remembered that Dev had some nice stuff for FTPing files. Figured that might help.
Sat, 07 Aug 2004 00:33:06 GMT

Tony Toew #12 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: >> I've purchased the Mabry controls a while back and the SMTP, POP3 and >> RAS controls worked quite well. >Their sample RAS code has a few holes in it - it makes a lot of potentially >invalid assumptions about NT phonebooks, but it handles the default >situation well. We pointed this out, sent improved code, they never put it >up on the site, o well. No problem with the control itself, mind, just with >the sample code. Hmmm, <recalling furiously> ah, I never bothered using the NT phone books. I had the user put the userid, password and phone number directly in my app. Scrambled the password before putting in a table of course. IIRC all I cared about was that there had to be one entry in the phonebook. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Sat, 07 Aug 2004 01:45:24 GMT

Bengt Lidgar #13 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Hi Steve, I'm again making a little more progress which is keeping me happy, but I have had a few problems getting SocketWrench to work. Before I go any further (and the documentation is good but not 100% not clear), is it sufficient with VBA 6.0 or do I need VB 2.0 at least? I would really appreciate an answer. Many thanks, Bengt Quote: > > And with the ODE/MOD but not with the Pro version of Access. And given > > all those OCX version problems I'm going to be closely looking at > > going straight API calls or a third party winsock control instead of > > Microsofts. > Can't blame you there. There's always info on this stuff in the VB > internet/controls sections. SocketWrench has a free Winsock control, I > think. Their stuff seems well documented also. > If you can find API code to do the job that'd be best, IMO. So many of > these controls are handy but require you to ship a meg worth of MFC > dependency bits and bobs. Foo. > Doesn't Dev Ashish have a site off the mvps.org site? Check his place. I > wouldn't be surprised if he had just the thing.
Sat, 07 Aug 2004 02:51:59 GMT

Steve Rindsber #14 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: > Hmmm, <recalling furiously> ah, I never bothered using the NT phone > books. I had the user put the userid, password and phone number > directly in my app. Scrambled the password before putting in a table > of course. IIRC all I cared about was that there had to be one entry > in the phonebook. We were trying to get our app to start a dialup, but only if needed. Several different operating systems, several different behaviors per OS, depending on which version of MSIE you used to break things... er, browse with, lotsa fun.
Sat, 07 Aug 2004 07:26:08 GMT

Steve Rindsber #15 / 21	Help!: Need to use Whois through VB. Nslookup not good enough to fin IP site names Quote: > Before I go any further (and the documentation is good but not 100% not > clear), is it sufficient with VBA 6.0 or do I need VB 2.0 at least? I haven't used it myself, other than to look at. Generally, anything that works in VB can be made to work one way or another in VBA.
Sat, 07 Aug 2004 07:27:24 GMT

Page 1 of 2

[ 21 post ]

Go to page: [1] [2]