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

[Swaminathan, Gayathri]

Jenu:

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
http://www.consultoria.eti.br/enus/download.php?file=3
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

HTH
Gayathri

> -----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
>