MAP not display from Sqlserver 2008 spatial DB

Oct 29, 2010 at 12:38 PM


Not able to disply map, error in map.zoomtoextent();

Error description : 

Cannot find either column "ST" or the user-defined function or aggregate "ST.AsBinary", or the name is ambiguous.

How to solve the problem.


Sandip Chakraborty



Oct 29, 2010 at 12:54 PM
Edited Oct 29, 2010 at 1:21 PM

If you want to use MsSqlSpatial you need to install an addition to SqlServer.

If you want to use SqlServer2008, use SqlServer2008 provider

Hth FObermaier

Oct 29, 2010 at 1:28 PM


I am using Sql serber 2008 spatil.

here also problem giving on myMap.ZoomToExtent().

Error Description Is:

A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry":
System.ArgumentException: 24144: This operation cannot be completed because the instance is not valid. Use MakeValid to convert the instance to a valid instance. Note that MakeValid may cause the points of a geometry instance to shift slightly.
   at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid()
   at Microsoft.SqlServer.Types.SqlGeometry.STEnvelope()

Help me please...



Oct 29, 2010 at 1:45 PM

May I draw your attention to patch 6438.

Hth FObermaier

Nov 1, 2010 at 9:42 AM


How to use patch, in my solution.

I am using latest release of the SHARP Map V 0.9 release dt. 21.10.2010 (binary).



Nov 1, 2010 at 6:35 PM

sandimchk, it is advised to compile sharpmap yourself. Grab yourself a copy of the source and replace the sqlserver2008.cs file by the one provided in the patch

Hth FObermaier