[MAPSERVER-USERS] mssql2008 binary test package available to download

BrainDrain paulborodaev at gmail.com
Thu Oct 16 03:20:00 EDT 2008 

ok
Now without mixing your package contens with older (ms4w_2.3.0 release)
dll's:
(I've attach my test database backup 
http://www.nabble.com/file/p20008430/geodb.zip geodb.zip )

-without "WITH(INDEX..." in mapfile data section - mem corruption exception
on "shape = layer.getFeature(featureIndexe, -1)" after successful execution
of queryByPoint (querying the largest polygon in my geodb);
-with using "WITH(INDEX...": 
msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL
statement: select convert(varchar(max), STATUS),convert(varchar(max),
STAGE),convert(varchar(max), id),GEOM from dbo.Construct
WITH(INDEX(SIndx_Construct_geometry_geom)) where id = 190748
-[Microsoft][ODBC SQL Server Driver][SQL Server]Query processor could not
produce a query plan because of the hints defined in this query. Resubmit
the query without specifying any hints and without using SET FORCEPLAN.
When I'm trying to execute this select statement in man. studio - error
message - the same.
I think because where clause don't contains conditions related to spatial
index used in 'WITH' hint.
OS: win2003 server std. sp2
My map file below:
 NAME "test map"
 STATUS ON
 CONFIG "PROJ_LIB" "c:/ms4w/app/WEMSite/Bin/proj/" 
 IMAGETYPE AGG_Q  
 IMAGECOLOR 255 255 255 
 EXTENT 24901 -5431142 67371 -5377561 
 SIZE 256 256
 FONTSET "../etc/fonts.fnt"
 SYMBOLSET "../etc/symbols.sym"   
 SHAPEPATH "../data" 
 UNITS meters 
 PROJECTION    	
	"+proj=tmerc +lat_0=48.70975 +lon_0=44.51205 +k=1.000000 +x_0=0 +y_0=0
+ellps=krass +towgs84=23.92,-141.27,-80.9,0,0,0,0 +units=m +no_defs"	
 END 
 QUERYMAP  
  STATUS OFF  
  STYLE HILITE  
 END
 REFERENCE
  STATUS ON
  IMAGE refmap.jpg
  SIZE 120 80    
  EXTENT -29603.5500 -33673.0980 13062.3500 19954.7270 
  COLOR -1 -1 -1
  OUTLINECOLOR 255 0 0
 END 
 LEGEND 
  STATUS OFF
  KEYSIZE 16 16    
  LABEL
   TYPE TRUETYPE
   FONT ninab
   COLOR 0 0 0
   SIZE 12   
  END
 END
 
 WEB
  LOG cicbase.log  
  IMAGEPATH "../tmp/"
  IMAGEURL "/tmp/"
  EXTENT -16000.0 -30000.0 19000.0 22500.0
  MINSCALE 1
  MAXSCALE 400000  
 END

LAYER
 NAME "construct"
 TYPE POLYGON 
 CONNECTIONTYPE PLUGIN
 PLUGIN "c:/ms4w/app/WEMSite/Bin/plugins/mssql/msplugin_mssql2008.dll"
 #CONNECTION "server=localhost;database=geodb;Integrated Security=true"
 CONNECTION
"server=localhost;uid=wem;pwd=spatialware;database=geodb;Integrated
Security=false"
 DATA "GEOM from dbo.Construct WITH(INDEX(SIndx_Construct_geometry_geom))
USING UNIQUE id USING SRID=0"
 #DATA "GEOM from dbo.Construct USING UNIQUE id USING SRID=0" 
 #PROCESSING "CLOSE_CONNECTION=DEFER" 
 TEMPLATE " " 
 STATUS ON
 TRANSPARENCY 100 #75
 TOLERANCE 12
 TOLERANCEUNITS pixels 
 #MAXSCALE 6000 
 PROJECTION
	"+proj=tmerc +lat_0=0 +lon_0=45 +k=1.000000 +x_0=0 +y_0=0 +ellps=krass
+towgs84=23.92,-141.27,-80.9,0,0,0,0 +units=mm +no_defs"
 END 
 CLASS
  NAME "Здания, сооружения"  
  STYLE
   COLOR 150 150 150
   OUTLINECOLOR 0 0 0
  END
 END 
END

IMAGEQUALITY 100
OUTPUTFORMAT
  NAME "AGG_Q"
  DRIVER "AGG/PNG"
  MIMETYPE "image/png; mode=8bit"
  IMAGEMODE RGB
  EXTENSION "png" 
  FORMATOPTION "QUANTIZE_FORCE=ON"
  FORMATOPTION "QUANTIZE_DITHER=OFF"  
  FORMATOPTION "QUANTIZE_COLORS=256"  
END

END


Tamas Szekeres wrote:
> 
> Hi,
> 
> I'm afraid I'd require further information about your environment,
> mapfiles, sample scripts to reproduce this problem.
> I've installed the binaries either with IIS and Apache but I haven't
> run into this problem, however I didn't mix the dll-s with other
> installations.
> 
> Here's a link to my installation displaying a single layer in IIS:
> http://vbkto.dyndns.org:1280/cgi-bin/mapserv.exe?mode=map&map=sql2008.map
> 
> And the same files working in Apache:
> http://vbkto.dyndns.org:1080/cgi-bin/mapserv.exe?mode=map&map=sql2008.map
> 
> The corresponding mapfile is looking something like:
> 
> MAP
> 	NAME "SQL2008"
> 	STATUS ON
> 	EXTENT 500000 300000 540000 340000
> 	SIZE 1000 1000
> 	IMAGETYPE PNG
> 	IMAGECOLOR 254 254 254
> 	PROJECTION
>   		"proj=somerc"
> 		"lat_0=47.14439372222222"
> 		"lon_0=19.04857177777778"
> 		"x_0=650000"
> 		"y_0=200000"
> 		"ellps=GRS67"
> 		"units=m"
> 		"no_defs"
> 	END
> 	SCALEBAR
> 		TRANSPARENT ON
> 		COLOR 0 0 64
> 		STATUS EMBED
> 		POSITION LR
> 		STYLE 1
> 		UNITS kilometers
> 		LABEL
> 			SIZE medium
> 			COLOR 0 0 64
> 		END
> 	END
> 
> 
> 
> 	LAYER	
> 		PROJECTION
>   			"proj=somerc"
> 			"lat_0=47.14439372222222"
> 			"lon_0=19.04857177777778"
> 			"x_0=650000"
> 			"y_0=200000"
> 			"ellps=GRS67"
> 			"units=m"
> 			"no_defs"
> 		END
> 		NAME "Erdo"
>                 TYPE LINE
>                 CONNECTIONTYPE PLUGIN
>                 PLUGIN "msplugin_mssql2008.dll"
>                 CONNECTION
> "server=.\MSSQLSERVER2008;database=geodb;Integrated Security=true"
>                 DATA "geom from erdo2 WITH(INDEX(geom_sidx)) USING
> UNIQUE ID USING SRID=0"
> 		STATUS DEFAULT
> 
>                 CLASS
> 			STYLE
>                                 COLOR 255 0 0
> 			END
> 			
> 		END
>         END
> END
> 
> 
> As far as I remember FCGI support haven't been enabled with these
> binaries.
> 
> Best regards,
> 
> Tamas
> 
> 
> 
> 2008/10/15 BrainDrain <paulborodaev at gmail.com>:
>>
>> I've tried this package
>> it looks promising:
>> but mapserv is unworking (maybe because I temporary mixed package with my
>> bin files): problems with loading dll dependences (libmap, fastcgi etc)
>> anyway mapscript_csharp draws layer from mssql2008 normally
>> querybypoint works (at first sight)
>> but now mapscript crashes (memory corruption) on layer.getFeature when
>> I'm
>> trying to get quered feature attributes
>>
>> please note that I had extra problems (mapserv illegal operation &
>> terminating) with option 'PROCESSING "CLOSE_CONNECTION=DEFER"' with
>> mssql2008 layer
>>
>>
>> Tamas Szekeres wrote:
>>>
>>> Hi All,
>>>
>>> For those who have problems compiling from the SVN I've uploaded my
>>> daily snapshot to this location:
>>>
>>> http://vbkto.dyndns.org:1280/tests/release-1400-20081013.zip
>>>
>>> This package should contain all of the related binaries compiled with
>>> MSVC2005. Please don't mix these dll-s with other compilations to
>>> avoid unexpected issues.
>>>
>>>
>>> Best regards,
>>>
>>> Tamas
>>> _______________________________________________
>>> 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/mssql2008-binary-test-package-available-to-download-tp19956347p19988521.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/mssql2008-binary-test-package-available-to-download-tp19956347p20008430.html
Sent from the Mapserver - User mailing list archive at Nabble.com.

More information about the mapserver-users mailing list