[Google Maps API v2] Re: Automatically Updating Google Map from Access DB?

On Oct 6, 4:16 pm, Phil Arbeau <parb...@gmail.com> wrote:
> Hello all,
>
> I am working on a project for school, where information is being put into an
> access data base. I then must geocode this data, and the final result is
> supposed to be a google map that the user can query. I was just curious if
> it were possible for the data on the map to automatically update as the
> database file updates.

Yes you can (but note that MS Access is not a robust database designed
for use on the web, it works OK for small sites, but if you are
expecting thousands of users, you should avoid it). The key is to use
AJAX to get the data out of the database (as xml or json),
periodically request data from the server with a unique URL (using a
cache busting time stamp).

See this page of Mike Williams' tutorial:
The Basics - Part 11 The AJAX Philosophy
http://econym.org.uk/gmap/basic11.htm

There are examples in the documentation of how to use PHP/MySql
(different database, potentially different server side language, but
the concepts apply):
http://code.google.com/apis/maps/documentation/javascript/v2/articles.html

-- Larry

>
> Thanks,
>
> Phil

--
You received this message because you are subscribed to the Google Groups "Google Maps API V2" group.
To post to this group, send email to google-maps-api@googlegroups.com.
To unsubscribe from this group, send email to google-maps-api+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.