Determining the geographics location of a visitor

Can I set the default currency by the visitor location.

[lgn]

Last year we Americanized our site. We used to have Canadian prices, but now we list our prices in American by default (as they outnumber us Canadians by 8 to 1).

The good news is that we doubled our American visitors. The bad news is we lost half our Canadian visitors, just because they would not click on the "Switch to Canadian" . I think we are getting quite a backlash, because Canadians don't like Canadian's that sell goods in US dollars, even though they have the option of changing currency back to Canadian. Our numbers speak well for this theory.

Now to solve the problem.

On the home page, we would like to have a script that will detect if the user's ISP is in Canada or not. This would involve a database lookup of ISP server addresses. If the server is in Canada, the customer gets Canadian Prices by default. If the customer is not in Canada, they get US prices by default.

Does such a database of ISP by location exist. Is
this feasible?

Im not looking for 100% perfection, as it is possible that a Canadian would suscribe to a US ISP provider, but I believe this would be uncommon if not rare. Even 90% accuracy would make me happy.

I have seen geotracking solutions for Fortune 500
companies, but they are way out of my price range.
Im looking for a cheap accuracy 90%+ of the time solution

Has anybody implemented this or have any susgetions before I go out and try to recreate the wheel.

[jatar_k]

maybe take a look at the links I have here ign. Seems like a good solution.

Country Detection via IP using PHP [webmasterworld.com]