[MAPSERVER-USERS] ms sql 2008 spatial - still problems???

[BrainDrain]

>>If you want I will give you that
It will be helpful
You are using dll from mapdotnet server?
I'm looking for
- some perfomance comparison (ms sql 2008 spatial vs postgis);
- suggestions, how to build optimal spatial index in ms sql 2008;


Venkatrao wrote:
> 
> Hi,
> 
>   I have code for Reading from postgre and writing into MsSql.If you want
> I will give you that.That is working great for me.What I feel is Postgre
> is better than Ms Sql.
> 
>  Have a look below urls
> 
> http://www.mail-archive.com/mapserver-users@lists.osgeo.org/msg00983.html
> 
> http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_postgis_mysql_compare
> 
> 
> let me know ..
> 
> Thanks and Regards
> Venkat.
> 
> -----Original Message-----
> From: mapserver-users-bounces at lists.osgeo.org
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of BrainDrain
> Sent: Friday, September 12, 2008 7:22 PM
> To: mapserver-users at lists.osgeo.org
> Subject: RE: [MAPSERVER-USERS] ms sql 2008 spatial - still problems???
> 
> 
> To import data into mssql 2008 I use FME 2008 (Safe Software)
> Which tool did you use?
> Can you share your dll?
> My layer config is similar to yours. I tried to delete 'using bla bla' but
> without effect. I tried to test  with&without creating spatial index.
> 
> Venkatrao wrote:
>> 
>> Hi,
>> 
>>    How you are importing your spatial data? Which tool you are using to
>> import spatial data?
>> 
>> Here is what I am using ,let me know if you are getting problem by using 
>> MsSQL 2008.
>>   CONNECTIONTYPE PLUGIN
>>   PLUGIN
>> "D:\home\Vtammineni\Data\sandbox\gis\RoulacGis\plugins\msplugin_mssql2008.dll"
>> #plug in
>>   CONNECTION
>> "server=192.168.1.79;uid=sa;pwd=asp123;database=testspatial;Integrated
>> Security=false"  # data base server connection
>>     DATA "geom from rgp_gis_worldcountries" # table
>> 
>> Thanks and regards,
>> Venkat.
>> 
>> 
>> -----Original Message-----
>> From: mapserver-users-bounces at lists.osgeo.org
>> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of BrainDrain
>> Sent: Friday, September 12, 2008 5:24 PM
>> To: mapserver-users at lists.osgeo.org
>> Subject: [MAPSERVER-USERS] ms sql 2008 spatial - still problems???
>> 
>> 
>> I tried to use ms sql 2008 layer with ms4w 2.2.9
>> my steps:
>> downloading mapdotnet & extracting msplugin_mssql2008.dll...done
>> importing data into mssql2008 using geometry data type (with FME) ...done
>> creating layer def:
>> ...
>>  TYPE POLYGON
>>  CONNECTIONTYPE PLUGIN
>>  PLUGIN "c:\ms4w\app\WEMSite\Bin\msplugin_mssql2008.dll"
>>  CONNECTION "server=localhost;uid=...;pwd=...;database=geodb;Integrated
>> Security=false"
>>  DATA "GEOM from dbo.Construct USING UNIQUE id USING SRID=0"
>> ...
>> done
>> and then exceptions:
>> 1) At server (asp.net) side on layer.open 
>> "msMSSQL2008LayerGetItems(): Query error. msMSSQL2008LayerGetItems: tried
>> to
>> find the geometry column in the results from the database, but couldnt
>> find
>> it.  Is it miss-capitialized? 'GEOM'"
>> googling - doesn't help, adding geometry_columns table (as it is in
>> postgis
>> db) and populating it - doesn't help, looking up in mapmssql2008.c -
>> doesn't
>> help, using sql profiler to catch what plugin requests - doesn't help
>> (((((((
>> 2) Ok: excluding layer.open() from code and waiting just for cgi
>> response:
>> Error executing MSSQL2008 SQL statement: SELECT
>> GEOM.STAsBinary(),convert(varchar(20), id) from dbo.Construct WHERE
>> GEOM.STIntersects(Geometry::STGeomFromText('POLYGON((-4850978.88931604
>> -7029571.83269322,-4800721.99088196 -7029571.83269322,-4800721.99088196
>> -6979314.93425899,-4850978.88931604 -6979314.93425899,-4850978.88931604
>> -7029571.83269322))',0)) = 1 -[Microsoft][ODBC SQL Server Driver][SQL
>> Server]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: в
>> Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() в
>> Microsoft.SqlServer.Types.SqlGeometry.STIntersects(SqlGeometry other) . 
>> Ok: executing "delete from dbo.Construct where GEOM.STIsValid()<>1" fixes
>> the 2nd problem
>> but what about 1st??? without solving this I'll not be able to perform
>> queries.
>> 
>> 
>> 
>> -- 
>> View this message in context:
>> http://www.nabble.com/ms-sql-2008-spatial---still-problems----tp19454300p19454300.html
>> Sent from the Mapserver - User mailing list archive at Nabble.com.
>> 
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> 
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> 
>> 
> 
> -- 
> View this message in context:
> http://www.nabble.com/ms-sql-2008-spatial---still-problems----tp19454300p19456310.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
View this message in context: http://www.nabble.com/ms-sql-2008-spatial---still-problems----tp19454300p19493660.html
Sent from the Mapserver - User mailing list archive at Nabble.com.