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

[Sinelnikov, Andrei]

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


Regards,

Andrei


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rodolfo
Moreno
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
selected


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
the
features is not possible.
The error shown in the log is: "sys.geometry is incompatible with
sys.geography"
The map that contains this layer is set as WGS 84.

any help will be appreciated, thanks

-----
Rodolfo Moreno
CivilEng

-- 
View this message in context:
http://n2.nabble.com/SQL-2008-Geographic-data-type-can%27t-be-selected-t
p2410036p2410036.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users


----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.