[mapserver-users] MS Access Databases

[Stephen Woodbridge]

I haven't done that yet, but I believe it is possible with mapscript. 

You can use the scripting language to query and ODBC connection to the
access database then use mapscript to a points and annotation to a layer
and then pass the generated map back to the user. On a query, you
retrieve the coordinate the user clicked on, map that back to some
lat/long value and perform a SQL query to see what items in the database
are close to the query point, then display back the results of the SQL
query.

Currently I think mapscript is only working for PHP, Perl, and Python.
Read up on mapscript, and check out the list archives.

-Steve

"Stephen D. King" wrote:
> 
> Hi everyone,
> 
> I have just started with the demo of MapServer and haven't done a lot with
> it yet. I wondered if it possible to query an MS Access database and plot
> the results to a map? Say if you have x,y coordinates, can you plot that
> point and query its attributes?
> 
> Many thanks,
> 
> Stephen