Geocode Addresses in T-SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by David Rueter » Geocode Addresses in T-SQL

52 posts, Page 6 of 6

«««2 3 4 5 6

Geocode Addresses in T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

David Rueter

Posted Friday, October 26, 2012 1:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:22 PM
Points: 44, Visits: 357

Sorry you are having problems. I just re-tested by downloading the unmodified Geocode.sql from the resources link at the end of the article and executed:

EXEC spGeocode '1234 N. Main Street, Santa Ana, CA'

I got valid results back:

33.755319 -117.867595 Santa Ana CA 92701 1234 N Main St ...

(FYI, I just re-tested on SQL 2005 and 2008 R2)

I suspect your database is not set to allow calls to OLE Automation procedures. (I tested this--if this is disabled, I do get a one-row resultset with nulls...along with an error message.)

To enable, execute the following:

EXEC sp_configure 'show advanced options';
RECONFIGURE;
EXEC sp_configure 'Ole Automation Procedures', 1;
RECONFIGURE;

If that is not the problem, you are likely dealing with some network issue--involving a proxy or filtering.

Post #1377422

Naresh Parmar

Posted Sunday, October 28, 2012 10:44 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, October 28, 2012 10:43 PM
Points: 3, Visits: 21

Thanks,

It works now.

I just execute below things:

EXEC sp_configure 'show advanced options';
RECONFIGURE;
EXEC sp_configure 'Ole Automation Procedures', 1;
RECONFIGURE;

Thanks a lot. :)

Post #1378095

« Prev Topic | Next Topic »

52 posts, Page 6 of 6

«««2 3 4 5 6

Permissions