Thanks Jeff, this is very weird. I tried for a long time to get it to work and the file exists (I copied/pasted the name). May I ask the following:

Hi Ira,

Does not seem to work for some cases... For example:

  select dbo.[fn_calculateJaro]('Busan-Gimhae LRT Warranty','Busan Gimhae')
returns 0 because of a dash character...

THANK YOU VERY MUCH patrickmcginnis59 for your suggestion, I created a System DSN (rather than an User DSN) and it worked!

Regards,

M.R.

It works on my system, I get:

33.755319-117.867595Santa AnaCA927011234 N Main St

but I modified the code to use Google API ver. 3 instead of ver. 2 referred in the article, please...

Hello,

I would suggest to use Google API ver. 3 (the current one) rather than ver. 2 referred in this post. Therefore, the URL should be something like:

http://maps.googleapis.com/maps/api/geocode/.....etc' - ver. 3

instead...

Procedure uses Geocoding API ver. 2 but can be updated in order to use Geocoding API ver. 3.

Regards,

M.R.

Please find the attached document below with all the screen shots of error message

We found the solution: it was a client browser setting:

Internet Options -> Privacy -> set it to 'Low"