>>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/[email protected]/msg00983.html > > http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_postgis_mysql_compare > > > let me know .. > > Thanks and Regards > Venkat. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of BrainDrain > Sent: Friday, September 12, 2008 7:22 PM > To: [email protected] > 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: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of BrainDrain >> Sent: Friday, September 12, 2008 5:24 PM >> To: [email protected] >> 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 >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> >> _______________________________________________ >> mapserver-users mailing list >> [email protected] >> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ > mapserver-users mailing list > [email protected] > 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. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
