Hi Robert<br><br>Thanks for the reply, you have got me to a point where ogrinfo commandline processes an ovf file using sql authentication fine. However it will still not display using shp2img commandline (other layer in mapfile draws fine). My layer definition is fairly simple, but I am scratching my head to think what is stopping the layer from drawing! The points are in standard lat/long so using WGS84 (layer and map projection).<br>
<br>Cheers<br>Chris<br><br>ovf contains<br><br><OGRVRTDataSource><br> <OGRVRTLayer name="omreg1"><br> <SrcDataSource>ODBC:user/xxxxxxx@conn</SrcDataSource><br> <SrcSQL>SELECT * FROM dbo.Site</SrcSQL><br>
<GeometryType>wkbPoint</GeometryType><br> <LayerSRS>EPSG:4326</LayerSRS><br> <GeometryField encoding="PointFromColumns" x="SiteLong" y="SiteLat"/><br>
</OGRVRTLayer><br></OGRVRTDataSource> <br>
<br>Layer defined as:<br><br> LAYER<br> NAME "test"<br> TYPE POINT<br> CONNECTIONTYPE OGR<br> CONNECTION "omreg.ovf" # the name and path to the virtual.ovf file, relative to shapepath may work?<br>
DATA "omreg1" # the name of the OGRVrtLayer<br> STATUS ON<br> LABELITEM "SiteName" #may need to use <a href="http://table.name">table.name</a> or just name depending on your OVF file.<br> PROJECTION<br>
"init=epsg:4326"<br> END<br> CLASS<br> SYMBOL 1<br> SIZE 6<br> COLOR 255 0 0<br> LABEL<br> SIZE MEDIUM<br> TYPE BITMAP<br> COLOR 0 0 0<br> END<br> END<br>END<br><br>