Hi,<br><br>I have problems to showing ovf layer on MapServer 4.8.1. Layer contains linestring-geometry from MySQL 5.0.18.<br><br>MapServer doesn't print any errors but layer won't show. Could somebody tell me what's wrong?
<br><br>Here is what is in ovf-file:<br><br><OGRVRTDataSource><br><br>    <OGRVRTLayer name="article_poly"><br>        <SrcDataSource>ODBC:opus@myodbc</SrcDataSource> <br>        <SrcSQL>select id, astext(article_poly.linest) as geometry from 
<br>article_poly</SrcSQL><br>        <GeometryField encoding="WKT" field="geometry"/><br>     </OGRVRTLayer><br><br></OGRVRTDataSource> <br><br>And what I get from ogrinfo:<br><br>
ERROR 4: Update access not supported for VRT datasources.<br>Had to open data source read-only.<br>INFO: Open of `/var/www/workshop/ovf/espoo.ovf'<br>using driver `VRT' successful.<br><br>Layer name: article_poly<br>Geometry: Unknown (any)
<br>Feature Count: 9<br>ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.<br>Extent: (34349.795000, 7989.500000) - (40567.791000, 79948.282000)<br>Layer SRS WKT:<br>(unknown)<br>id: Integer (2.0)<br>geometry: String (
111.0)<br>ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.<br>OGRFeature(article_poly):0<br>  id (Integer) = 1<br>  geometry (String) = LINESTRING(36389.217 75489.802,36580.774 75200)<br>  LINESTRING (
36389.217 75489.802,36580.774 75200.000)<br><br>OGRFeature(article_poly):1<br>  id (Integer) = 2<br>  geometry (String) = LINESTRING(34501.916 76285.895,34349.795 76149.853)<br>  LINESTRING (34501.916 76285.895,34349.795 
76149.853)<br><br>OGRFeature(article_poly):2<br>  id (Integer) = 10<br>  geometry (String) = LINESTRING(40567.791 79786.741,40566.862 79786.955,40558.5 79809,40561 7989.5,40567.791 79822.157)<br>  LINESTRING (40567.791 79786.741
,40566.862 79786.955,40558.500 79809.000,40561.000 7989.500,40567.791 79822.157)<br><br>OGRFeature(article_poly):3<br>  id (Integer) = 4<br>  geometry (String) = LINESTRING(40567.791 79812.987,40566.526 79813.667,40567.791
 79815.626)<br>  LINESTRING (40567.791 79812.987,40566.526 79813.667,40567.791 79815.626)<br><br>OGRFeature(article_poly):4<br>  id (Integer) = 5<br>  geometry (String) = LINESTRING(40241.658 79840.44,40247.668 79840.383,
40247.559 79828.962,40241.551 79829.08,40241.658 79840.44)<br>  LINESTRING (40241.658 79840.440,40247.668 79840.383,40247.559 79828.962,40241.551 79829.080,40241.658 79840.440)<br><br>OGRFeature(article_poly):5<br>  id (Integer) = 6
<br>  geometry (String) = LINESTRING(40567.791 79808.936,40567.054 79805.977,40566.933 79802.648,40567.495 79798.888,40567.791 79798.958)<br>  LINESTRING (40567.791 79808.936,40567.054 79805.977,40566.933 79802.648,40567.495
 79798.888,40567.791 79798.958)<br><br>OGRFeature(article_poly):6<br>  id (Integer) = 7<br>  geometry (String) = LINESTRING(40273.209 79941.596,40271.197 79945.203,40276.716 79948.282,40280.146 79942.135,40281.583 79939.558
)<br>  LINESTRING (40273.209 79941.596,40271.197 79945.203,40276.716 79948.282,40280.146 79942.135,40281.583 79939.558)<br><br>OGRFeature(article_poly):7<br>  id (Integer) = 8<br>  geometry (String) = LINESTRING(40227.602
 79816.024,40226.05 79815.86,40222.053 79815.437,40222.736 79808.973,40228.096 79809.54)<br>  LINESTRING (40227.602 79816.024,40226.050 79815.860,40222.053 79815.437,40222.736 79808.973,40228.096 79809.540)<br><br>OGRFeature(article_poly):8
<br>  id (Integer) = 9<br>  geometry (String) = LINESTRING(40267.509 79884.152,40265.504 79887.333,40267.102 79888.341,40269.108 79885.161,40267.687 79884.264)<br>  LINESTRING (40267.509 79884.152,40265.504 79887.333,40267.102
 79888.341,40269.108 79885.161,40267.687 79884.264)   <br><br>And layer definition from map-file:<br><br>       LAYER<br>                CONNECTION "ovf/espoo.ovf"<br>                CONNECTIONTYPE OGR<br>                NAME article_poly
<br>                TYPE LINE<br>                STATUS DEFAULT<br>                CLASS<br>                 DEBUG ON<br>                  STYLE<br>                   COLOR 255 0 0<br>                  END<br>                END
<br>                <br>        END <br><br>--<br>Best Regards, Tero<br>