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: [email protected] [mailto:[email protected]] On Behalf Of Rodolfo Moreno Sent: Monday, March 02, 2009 9:15 AM To: [email protected] 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 [email protected] 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. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
