[Mapserver-users] Data Connection with MS-SQL database

Swaminathan, Gayathri gayathri at ou.edu
Mon May 10 09:33:01 EDT 2004


I am not sure you have trouble figuring something similar to the
scenario below, but here goes it,

1) Data in MSSQL
2) Convert to Access MDB format
2) Export to ESRI Shapefile- using a tool like MDB2Shapefile
3) Export shapefile to Postgres/Postgis using shp2pgsql
4) Have a layer in map file connecting to Postgis to implement this 
5) Join search results from table in SQL with the table in Postgres to
obtain the_geom


> -----Original Message-----
> From: mapserver-users-admin at lists.gis.umn.edu 
> [mailto:mapserver-users-admin at lists.gis.umn.edu] On Behalf Of 
> Jenu Abraham
> Sent: Sunday, May 09, 2004 10:47 PM
> To: mapserver-users at lists.gis.umn.edu
> Subject: [Mapserver-users] Data Connection with MS-SQL database
> Hi guys,
> need some kind of direction as to how to get lat long 
> information from my 
> MS-SQL database to integrate with mapserver
> i'm totally lost as to how get this done....
> thanks
> jenu
> _________________________________________________________________
> MSN Toolbar provides one-click access to Hotmail from any Web 
> page - FREE 
> download! http://toolbar.msn.com/go/onm00200413ave/direct/01/
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu 
> http://lists.gis.umn.edu/mailman/listinfo/maps> erver-users

More information about the mapserver-users mailing list