Or you could use the OGR ODBC driver directly by creating a view with an additional WKT column from your x, y fields and add this view to the GEOMETRY_COLUMNS table in your database
For the OGR ODBC format visit: http://www.gdal.org/ogr/drv_odbc.html Tamas On Sat, 25 Mar 2006 10:09:09 +0100, Bart van den Eijnden (OSGIS) <[EMAIL PROTECTED]> wrote: >You should be able to do that using OGR's Virtual Spatial Data, and >using ODBC to connect to your SQL Server database. > >http://www.gdal.org/ogr/drv_vrt.html > >Best regards, >Bart > >Chip Taylor wrote: > >> Can I integrate a layer in Mapserver using a connection to Microsoft >> SQL Server 2005, pulling XY (lat long) points and text, and plot >> these? How would I do that? >> >> >> >> >> >> Chip Taylor >> >> Prepared Response, Inc >> >> >> > > >-- >Bart van den Eijnden >OSGIS, Open Source GIS >http://www.osgis.nl
