[Mapserver-users] Displaying x-y Datasets using PHP/Mapscript

[Normand Savard]

Hi Jan,

Frank sent a set debugging rules to follow on this mailing list 
already.  Maybe you could have a look to the following:

http://mapserver.gis.umn.edu/cgi-bin/wilma_hiliter/mapserver-users/0402/msg00253.html

Also to verify if your current gdal/ogr installing support ODBC, you 
could do "ogrinfo --formats".



Norm

Jan Vietmeier wrote:

>Hi,
>Thanks a lot for the Help. In the meantime I am able to dynamically add
>points to a layer using PHP/Mapscript, but the method suggested by Zak seems
>to be the best solution for my purpose.
>
>Now I am wading through the manual
>http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData and
>everythink is working fine including the step "Testing" ... the virtual data
>file ... "using ogrinfo". The implementation into Mapserver fails with the
>error Message "... [MapServer Error]: msOGRFileOpen(): Open failed for OGR
>connection `D:\www\data\shapes\punktquelle.ovf'. File not found or
>unsupported format ...".
>
>In my opinion, this can have two reasons:
>
>1. My version of ogrinfo is from the openev_fw-Program downloaded at
>http://www.remotesensing.org and my mapserver-version is the binary-version
>from DM Solutions (mapserver-4.0-win32-php4.3.2.zip from 26-Aug-2003). Maybe
>my mapserver-version don't supports virtual layer.
>
>How can I find out if my gdal11.dll supports the ogr-vrt format (does
>gdalxx.dll contains ogr?)
>
>2. There is someting wrong with my mapfile or punktquelle.ovf-file. Here
>some code-snipps:
>The virtual layer file:
>
><OGRVRTDataSource>
>    <OGRVRTLayer name="tbl_einsatz">
>        <SrcDataSource>ODBC:@myeinsatz</SrcDataSource>
> 	     <SrcTable>tbl_einsatz</SrcTable>
>	     <GeometryType>wkbPoint</GeometryType>
>	     <GeometryField encoding="PointFromColumns" x="x" y="y"/>
>    </OGRVRTLayer>
></OGRVRTDataSource>
>
>The Mapfile:
>
>  LAYER
>    NAME "MyVirtualLayer"
>    TYPE POINT
>    CONNECTIONTYPE OGR
>    CONNECTION "D:\www\polizei\data\shapes\punktquelle.ovf" # the name and
>path to the virtual.ovf file, relative to shapepath may work?
>    DATA "tbl_einsatz" # the name of the OGRVrtLayer
>    STATUS ON
>    LABELITEM "Einsatz" #may need to use table.name or just name depending
>on your OVF file.
>    PROJECTION
>      "init=epsg:31468"
>    END
>    CLASS
>      SYMBOL 1
>      SIZE 6
>      COLOR 255 0 0
>      LABEL
>	SIZE MEDIUM
>	TYPE BITMAP
>	COLOR 0 0 0
>      END
>    END
>  END
>
>Does anyone have an idea?
>
>Tanks,
>
>Jan
>
>
>Jan Vietmeier, Diplom-Geograph
>Im Fichtenhain 18
>51069 Köln
>
>Tel.  +49 (0)221 9468252
>Mobil +49 (0)178 3744854
>Fax.  +49 (0)221 9468251
>
>
>
>_______________________________________________
>Mapserver-users mailing list
>Mapserver-users at lists.gis.umn.edu
>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>  
>