OGR Virtual

[Frank Fica]

Hello,

I've been trying to map a non-spatial postgre table with ogr via ODBC but no success. There must
be a simple solution to what I'm missing and I haven't been able to figure it out. My other layers
do render but my Virtual layer doesn't. When I test in ogrinfo I can connect but when I try to map
in mapserver the image is blank, only my mapinfo layer renders.

Does someone has any suggestions on what I'm missing?

Here are is my ovf file:

<OGRVRTDataSource>
    <OGRVRTLayer name="sorento">
        <SrcDataSource>ODBC:@PostgreSQL,sorento</SrcDataSource>
        <SrcLayer>sorento</SrcLayer>
        <GeometryType>wkbPoint</GeometryType>
        <GeometryField encoding="PointFromColumns" x="Lon" y="Lat"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

and map file:

MAP
  IMAGETYPE PNG
  EXTENT -90.760314 14.252771 -90.210352 14.937117
  SIZE 640 480
  UNITS METERS

  SYMBOL
   NAME "circle"
   TYPE ELLIPSE
   POINTS
    1 1
   END
   FILLED TRUE
  END

 LAYER
  NAME "ciudad"
  TYPE POLYGON
  STATUS ON
  CONNECTIONTYPE OGR
  CONNECTION "/var/www/html/guatemala/data/ciudad.tab"
  STYLEITEM "AUTO"
    CLASS
      NAME "Ciudad"
    END
 END

 LAYER
    NAME "sorento"
    TYPE POINT
    CONNECTIONTYPE OGR
    CONNECTION "virtual.ovf"
    DATA "sorento"
    STATUS DEFAULT
    CLASS
      STYLE
      SYMBOL 'circle'
      SIZE 30
      COLOR 255 0 0
      END
     END
 END
END