[mapserver-users] msplugin_mssql2008.dll plugin seems to work but I obtain a blank image

[James Perrins]

Is it a projection issue - I have to do the below to get the geometry
out correctly I think (at least it works!)

  CONNECTION "server=JAMESIBM\sql2008;uid=test;
               pwd=test;database=Test;
                 Integrated Security=false"
  DATA "geom from Wales USING UNIQUE OBJECTID USING SRID=27700"
  TYPE POLYGON
  STATUS ON
  TEMPLATE "AB"
	PROJECTION
		"init=epsg:27700"
	END

Best wishes

On Wed, Feb 24, 2010 at 5:18 PM, Kiks <enrico.oemi at gmail.com> wrote:
>
> Hi to all,
> I have imported in Sql Server 2008 spatial a shp file.
> Now, if I access the original shape file via WMS it works fine. This is the
> mapfile config relative to the working shp file:
>
> LAYER
>     NAME "ptcp"
>     TYPE POLYGON
>     STATUS DEFAULT
> #     CONNECTIONTYPE PLUGIN
> #    PLUGIN "C:\programmi\ms4w\Apache\specialplugins\msplugin_mssql2008.dll"
> #     CONNECTION "Driver={SQL Server Native Client
> 10.0};Server=localhost\SQLEXPRESS; Database=GIS;Trusted_Connection=yes;"
> #     DATA "geom FROM CG_PTCP_C6_AREE_NATURALI"
>     DATA "E:\Dati cartografici Comuni\Parma PTCP\ptcp
> gauss\C6\aree_naturali.shp"
>     METADATA
>       "wms_title" "Aree naturali"
>       "gml_include_items" "all"
>     END
>        DUMP TRUE
>     OPACITY 50
>     CLASS
>     STYLE
>       COLOR 0 0 255
>       # WIDTH 8
>     END
>     LABEL
>       TYPE truetype
>       FONT "PerspectiveBlack"
>       SIZE 11
>     END
>  END
>
> If I remark the row DATA "E:\.... \aree_naturali.shp" and I remove the # in
> the previous lines to enable the Sql Server 2008 call, executing the WMS
> call from browser I obtain a blank image.
>
> I can't understand the different beaviour, because the geometry in Sql
> Server is the same, and the connection is accepted correctly.
> Any ideas?
>
> Thanks a lot,
> Kiks
> --
> View this message in context: http://n2.nabble.com/msplugin-mssql2008-dll-plugin-seems-to-work-but-I-obtain-a-blank-image-tp4627179p4627179.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
>



-- 
Dr James Perrins
exeGesIS SDM Ltd
Great House Barn
New Street, Talgarth
Powys LD3 0AH.
Direct Line: 01646 686650
Tel: 01874 711145
Fax: 01874 711156
Email: JamesP at esdm.co.uk

This E-mail and any files transmitted with it are private and intended
solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient, the E-mail and any
files have been transmitted to you in error and any copying,
distribution or other use of the information contained in them is
strictly prohibited.

Nothing in this E-mail message amounts to a contractual or other legal
commitment on the part of exeGesIS SDM Ltd unless confirmed by a
signed communication.

exeGesIS SDM Ltd will make every effort to keep its network free of
viruses. However, the recipient of this message will need to scan this
message, and any attachments, for viruses, as exeGesIS SDM Ltd can
take no responsibility for any computer virus that might be
transferred by this e-mail.