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

Venkat Rao Tammineni vtammineni at roulacglobal.com
Mon Sep 15 01:04:37 EDT 2008


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



More information about the mapserver-users mailing list