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ä: [EMAIL PROTECTED] puolesta: Ivan Mincik Lähetetty: ke 24.9.2008 19:09 Vastaanottaja: [email protected] 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/[EMAIL PROTECTED]</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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
