[mapguide-users] SQL 2008 Geographic data type can't be selected

Sinelnikov, Andrei AndreiSinelnikov at SierraSystems.com
Mon Mar 2 12:48:35 EST 2009

Hello Rodolfo,

Make sure you set SRID while populating SQL:

, [Geo] = GEOMETRY::STGeomFromText([import].[Geo], @SRID)

Base on your map (WGS 84) your SRID should be something like 4326



-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rodolfo
Sent: Monday, March 02, 2009 9:15 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] SQL 2008 Geographic data type can't be

I have could select features from geometric data type (sql 2008 as data
source) however, for the case of geographic data type the selection of
features is not possible.
The error shown in the log is: "sys.geometry is incompatible with
The map that contains this layer is set as WGS 84.

any help will be appreciated, thanks

Rodolfo Moreno

View this message in context:
Sent from the MapGuide Users mailing list archive at Nabble.com.

mapguide-users mailing list
mapguide-users at lists.osgeo.org

----Notice Regarding Confidentiality----
This email, including any and all attachments, (this "Email") is intended only for the party to whom it is addressed and may contain information that is confidential or privileged.  Sierra Systems Group Inc. and its affiliates accept no responsibility for any loss or damage suffered by any person resulting from any unauthorized use of or reliance upon this Email.  If you are not the intended recipient, you are hereby notified that any dissemination, copying or other use of this Email is prohibited.  Please notify us of the error in communication by return email and destroy all copies of this Email.  Thank you.

More information about the mapguide-users mailing list