Geocoding problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Geocoding problem

Author

Topic

kunaaldesai
Starting Member

36 Posts

Posted - 2009-08-01 : 16:55:43

Hey guys,

I am new to spatial databases. I am using sql server 2008 and trying to do something like following:

@addr nvarchar(256) = '2650 college place, Fullerton, CA, 92831';
DECLARE @addr_as_xy nvarchar(30);
DECLARE @g geography;
SET @addr_as_xy = dbo.geocoder(@addr)
SET @g = geography:: STPointFromText(@addr_as_xy, 4326)

This code basically converts a simple text address into ( X,Y) coordinates system.

Now, It gives me following error:

Msg 4121, Level 16, State 1, Line 4
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.geocoder", or the name is ambiguous.

I really don't know why I just copied and pasted the caode from the microsoft tutorial.

Can anybody help please?

Kunal

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-01 : 16:57:37

Do you have a link to the tutorial?

N 56°04'39.26"
E 12°55'05.63"