[mapserver-users] RE:mapserver + MS SQL

[Rahkonen Jukka]

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.

-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