Hi,
The MSSQL 2008 driver only compatible with the Geometry data type at the
moment. In case if the Geography data type is used the spatial filter should
also be specifyed as Geography which is not the case in the current
implementation. You might want to submit a ticket describing the issue and
To clarify I have a column in SQL 2008 of type geography that I would like to
use in map server. I have been able to do this using the OGR ODBC driver.
However, when trying to use the Native SQL 2008 driver that has been added to
MS4W 2.3.1 I get the error message sys.geometry is incompatible
@lists.osgeo.org
Subject: [mapserver-users] Using the SQL Server 2008 Plugin with a Geography
column
Has anyone been able to get the SQL Server 2008 plugin to work against a
geography column.
I have been using the following DATA Statement
DATA the_geom FROM Types USING UNIQUE ID USING SRID=4326
Has anyone been able to get the SQL Server 2008 plugin to work against a
geography column.
I have been using the following DATA Statement
DATA the_geom FROM Types USING UNIQUE ID USING SRID=4326
and get the response, sys.geometry is incompatible with sys.geography due to
the spatial filter