[mapserver-users] RE:mapserver + MS SQL

[Ivan Mincik]

> Hi,
> 
> First thing that comes into my mind is the good old STATUS ON thing.  LAYER ON in mapfile means that the layer can be requested, but not that it is automatically included in a map.  STATUS DEFAULT includes it automatic.  Try what happens if you use:
>  
> shp2img -m test.map -l ku2 -o test.png
> 
> Alternatively, change LAYER DEFAULT and use the old command.
> 
Thanks for reply, 
still blank picture, with "shp2img -m test.map -l ku2 -o test.png" also blank. BTW: for other data sources layer configuration is 
working.


> -Jukka Rahkonen-
> 
> 
> -----Alkuperäinen viesti-----
> Lähettäjä: mapserver-users-bounces at lists.osgeo.org puolesta: Ivan Mincik
> Lähetetty: ke 24.9.2008 19:09
> Vastaanottaja: mapserver-users at lists.osgeo.org
> Aihe: [mapserver-users] RE:mapserver + MS SQL
>  
> I have started testing OGR ODBC connection from linux to MS SQL on win.
> There is polygon layer at MS SQL.
> 
> *** I have configured ovf file:
> 
> <OGRVRTDataSource>
>     <OGRVRTLayer name="ku2">
>         <SrcDataSource>ODBC:test/test at win</SrcDataSource> 
>     <GeometryType>wkbPolygon</GeometryType> 
>         <LayerSRS></LayerSRS>
>     <GeometryField encoding="wkb" field="geom"/>
>     <SrcSQL>select geom from ku2</SrcSQL>
>     </OGRVRTLayer>
> </OGRVRTDataSource>
> 
> *** With ogrinfo -ro -al test.ovf I get:
> 
> OGRFeature(ku2):1599
>   geom (Binary) = 000000000104BA0000003EB1148070BF20C15D1DF97FB5C832C11B1727C08FBF20C16F23...
>   POINT (0.0 -0.0)
> 
> OGRFeature(ku2):1600
>   geom (Binary) = 000000000104C8010000C23023A08D2C19C1BC001400308E32C1C84A35A0372C19C1CF70...
>   POINT (0.0 -0.0)
> 
> OGRFeature(ku2):1601
>   geom (Binary) = 0000000001047905000038864D009A7818C19A41F1FF68B732C19092B3BF6C7818C10808...
>   POINT (0.0 0.0)
> 
> 
> *** In the mapfile :
> 
> LAYER 	
>     NAME 'ku2'
>   	DEBUG 5
>     	TYPE LINE
> 	CONNECTIONTYPE OGR
> 	CONNECTION "test.ovf"
>     	DATA "ku2"
>         	STATUS ON
>         	PROJECTION
>                 	"init=epsg:2065" 
>         	END
>         	METADATA
>                 	"DESCRIPTION"   "test"
>                  	'wms_title' 'test'
>                  	"wms_format"          "image/png"
>         	END
>         	CLASS
>                 	NAME "test"
>                 STYLE
>                         OUTLINECOLOR  239 110 115
>                         COLOR 204 204 204
>                         WIDTH 8
>                 END
>         END
> END
> 
> *** shp2img -m test.map -o test.png will run without error, but output image is BLANK.  Any idea ?
> I have tried this with 2 different layers, different coordinate systems.
> 
> 
> 
> 
> >Hi list,
> >At first, I would like to say that I am not a fan in replacing perfect PostGIS database to MS SQL, but I must to adapt to customer's needs.
> >I would like to ask if somebody has experience with loading data to mapserver from MS SQL Spatial 2008.
> >Now, in 5.2 there is possibility to use new PLUGIN for MS SQL, which is only for Windows ....
> >Other possibility is to use ODBC connection through OGR which can be working also in Linux.
> >
> >So my questions are :
> >1. Is there any other possibility ?
> >2. What is Your experience with performance when using ODBC connection through OGR ? 
> >3. What is Your experience with performance when using new PLUGIN for MS SQL in 5.2 ?
> >
> >Thanks a lot 
> >-- 
> 
> >Ivan 
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
Mgr. Ivan Minčík
Gista s.r.o
tel:. 0907 639 570
email: ivan.mincik at gista.sk
http://www.gista.sk, http://demo.gisplan.sk


-------------------------------------------------------

-- 
Mgr. Ivan Minčík
Gista s.r.o
tel:. 0907 639 570
email: ivan.mincik at gista.sk
http://www.gista.sk, http://demo.gisplan.sk