Library tutorials & articles

Extracting the Country from the IP Address:- How To?

The Database

There are many services, both Free & Commercial, which provide you the geographic data of the visitors to your website. We will however use the free IP-Country database provided by
http://ip-to-country.webhosting.info. This database is available in the CSV format & can be imported into other databases like MS-Access, MS-SQL, MySQL, etc. Since we will be using ASP & MS-Access, we will thus download this csv database & import it into an MS-Access database.
The MS-Access database containing the records from the downloaded csv database is attached with this tutorial. The full code used in this tutorial is at the end.

So after importing the CSV file into an MS-Access database, we name the database as ip2country & the table as ip2c.
Now, there are 5 columns in our table ip2c, namely, ip_from, ip_to, co_code2, co_code3 & co_name.
Instead of storing IP Address, which are in format xxx.xxx.xxx.xxx, this database has IP number ranges. The ip_from marks the beginning of range & ip_to ends it. The co_code2 column has the 2Digit country code & co_code3 has 3Digit Country Code. The column co_name has the full country name.

Now we will proceed to writing the ASP code.

Comments

  1. yesterday

    Thanks for the comment..i really like this..

    Get your Term papers done - FlashPapers.com

  2. yesterday

    You can check Country, City, ZIP, Longitude and Latitude in C# and visual basic (VB.NET). There is source code for .NET GeoIP: http://tools.webmastermafia.com

    You can use it for FREE. It is very easy, just 2 lines of code.

  3. 08 Sep 2009 at 16:34

    thanks a lot...it would me more useful if you post it in VB.NET..or C# ..thanks in advance

  4. 08 Sep 2007 at 19:46

    I just wrote a lasted sample which describes how to get countries and city from IP address and  the sample contains a IP database.If you want to get the sample code,Please visite http://www.treaple.com/bbs/index.php or http://www.treaple.com/bbs/thread-17-1-1.html

  5. 02 Sep 2007 at 18:06

    First of all,you should get a database which includes all countries IP details.

    and then convert IP address to decimal   to find the exact country name by the decimal   .

  6. 02 Sep 2007 at 18:02

    I hope that this article can be used for you

    http://www.treaple.com/ArticlesDetails.aspx?id=55

    cheer.

  7. 03 May 2007 at 14:37

    Hi Guys,

    Though this is a brilliant piece of code, can u guys please explain that what are the datatypes used in the function ipAd2ipNum and also it gives me an error if i use the datatypes like integer, int32, int64...Please reply asap Rohit Smiley Face [:)]

  8. 11 Nov 2006 at 16:43

    Thanks a lot.Smiley Face [:)]Crying [:'(]

  9. 06 Jun 2006 at 19:07

    Hi,

    First i woud like to thank you fom the bottom of my heart, on this wounderful, well orginized article, it really helped me a lot, i have been looking for a one like this for a long time

    THANX A LOT

    btw, i guese you have forgotten about the database anyway,
    i'll do u simple favor for you and others as little return for this article

    the link for the latest CSV Values

    http://ip-to-country.webhosting.info/downloads/ip-to-country.csv.zip

     

    Once again, Thanx a lot

     

    Best Regards

  10. 14 Nov 2005 at 12:30

    How to download the MS Access database?

  11. 28 Oct 2005 at 18:42

    If your wondering why "strIP = Request.ServerVariables("HTTPREMOTEADDR")" returns no IP address change it too "strIP = request.servervariables("REMOTE_ADDR")" and this will now work !

  12. 01 Jan 1999 at 00:00

    This thread is for discussions of Extracting the Country from the IP Address:- How To?.

Leave a comment

Sign in or Join us (it's free).

Amit Gupta

Want to stay in touch with what's going on? Follow us on twitter!