MAP not display from Sqlserver 2008 spatial DB

Oct 29, 2010 at 1:38 PM

Hi,

Not able to disply map, error in map.zoomtoextent();
using sharpmap.provider.data.MsSqlSpatial(...);

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.

Regards

Sandip Chakraborty

 

 

Coordinator
Oct 29, 2010 at 1:54 PM
Edited Oct 29, 2010 at 2: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 2:28 PM

Hi,

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.
System.ArgumentException:
   at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid()
   at Microsoft.SqlServer.Types.SqlGeometry.STEnvelope()

Help me please...

Sandip

 

Coordinator
Oct 29, 2010 at 2:45 PM

May I draw your attention to patch 6438.

Hth FObermaier

Nov 1, 2010 at 10:42 AM

Hi,

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

Sandip

 

Coordinator
Nov 1, 2010 at 7: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