Using Microsoft SQL Server?

[Tamas Szekeres]

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)
<bartvde at XS4ALL.NL> 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