Thank you Jackie, I do not care about spatial preview that much. I just want SQL FDO to work and looks like it is not cooperating. For example if I am trying to set map extents to the layer extents I see following error:
http://osgeo-org.1803224.n2.nabble.com/file/n5206134/RoadSQL.png I am using SQL Views with join to show features on the layer: CREATE VIEW [geo].[vw_Road_Roadway] WITH SCHEMABINDING AS SELECT [base].[Id] , [CategoryId] , [SpatialStatusId] , [LifecycleStatusId] , [MaterialId] , [AddressId] , [DisplayId] , [SpatialId] , [ReportingId] , Year([StatusDate]) StatusYear , convert(varchar,[StatusDate],101) StatusDate , [LocationDescription] , [Geo] , [Length] FROM [dbo].[Asset] [base] INNER JOIN [dbo].[Road_Roadway] [asset] ON [base].[Id] = [asset].[Id] WHERE [base].[Geo] IS NOT NULL AND [base].[SpatialId] IS NOT NULL GO but binding layer to the table instead of view not helping. Basically - I am not able to retrieve spatial data from MS SQL and present it on the map -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/MGOS-v2-2-Beta-and-SQL-2008-Again-tp5197257p5206134.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
