Re: [UMN_MAPSERVER-USERS] Point data from SQL Server

[Milo van der Linden]

Hi Jerry!

The best way to go for you is using a virtual format datasource like
described on:
http://www.gdal.org/ogr/drv_vrt.html

This way you connect to your SQL server database like:

<OGRVRTDataSource>
    <OGRVRTLayer name="mypointstable">
        <SrcDataSource>ODBC:SQLSERVER CONNECTION</SrcDataSource>
        <SrcLayer>worms</SrcLayer>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="x" y="y"/>
    </OGRVRTLayer>

If this won't work, nothing will!

Kind regards!
Milo van der Linden


> Hi,
>
> I have point data in SQL Server (X,Y Columns in a table), what is the best
> way to display this in
> mapserver..ideally without having to transform it to another data format.
>
> Thanks in advance
> Jerry
>


Milo van der Linden

<a href="http://somafm.com/";><img
src="http://somafm.com/linktous/450x25sfm1.gif"; alt="SomaFM" border=0
width=450 height=25 ></a>