[MAPSERVER-USERS] mssql2008 binary test package available to download
BrainDrain
paulborodaev at gmail.com
Thu Oct 16 00:20:00 PDT 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