have anyone used this before, i need free country, city, IP database for sqlserver
+5
A:
If you need to find the location of the current user based on their IP address, then you could try the Google Geolocation API, in particular google.loader.ClientLocation.
Check out the Google API docs for more info: http://code.google.com/apis/ajax/documentation/#ClientLocation
cxfx
2009-03-07 05:21:01
+1 'cause that's right, but in my experience it very often has no idea where you're from. At least it tells you when it doesn't know. Seems to be better IDing residential things than commercial.
Jason Cohen
2009-10-11 05:16:26
+2
A:
I have used http://www.maxmind.com/app/geolitecity . It is a less exact version of their paid database. The free database claims to be "over 99.5% on a country level and 79% on a city level for the US within a 25 mile radius". You can see their accuracy detailed at http://www.maxmind.com/app/geolite_city_accuracy.
The data is presented as a CSV file containing the starting IP block, ending IP block, and the location. It is easy enough to load into sqlserver.
Nathan Voxland
2009-03-07 06:29:10
+4
A:
ipinfodb provide free geolocation data for MySQL. With a simple database translator, you can put it into different database, since the table structure is simple. They also provide data in CSV format, that will be easier to imported to different database engine.
The data is based on free version of MaxMind, and it's updated every month. They also provide free API, if you don't want to store the data in your server. The accuracy is decent and enough for normal website usage.
Donny Kurnia
2010-01-13 13:18:09