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
