Geocode SQL 2008 Table and Display using JavaScript API

BradOleson

I have a task in which I have a table of addresses in a SQL Server 2008 table.  I need to display these as referenced points in a map via JavaScript API.  The addresses in the table are dynamic and change, so this won't work as a feature class.  What is the best method to accomplish this?  Thanks!

B

HemingZhu

I have a task in which I have a table of addresses in a SQL Server 2008 table.  I need to display these as referenced points in a map via JavaScript API.  The addresses in the table are dynamic and change, so this won't work as a feature class.  What is the best method to accomplish this?  Thanks!

B

One approach i would take would be a GP services (Add X, Y as a layer or GeoCode etc. base on your date) with result/event layer on your mxd. There are certain limitations though if your SQL server table does not have OBJECTID field. So I would suggest you registered you table with Geodatabase. It really does not affect non GIS access to the table.