[maplab-users] ODBC -OGR Connection - OVF file- MapLab

[Zak James]

Aldo,

The usual problem with this setup is that mapserver doesn't have the
same environment variables available to it when accessing the layer as
the command shell does. I'm not sure of the specifics of connecting to
Access, but you might try looking at what environment variables are
set in the shell where you're running ogrinfo.

zak
--
Zak James
Applications and Software Development
DM Solutions Group Inc.
http://www.dmsolutions.ca

On Fri, 10 Dec 2004 14:46:50 +0100, Aldo Tocchio
<a.tocchio at arpa.piemonte.it> wrote:
> Hi to all,
> 
> """Sorry for my bad english....""""
> 
> I replaced my version of MS4w with a new  one (ms4w_1.0.1.zip) . I also installed
> the latest  version of  maplab_ms4w-2.2.zip.
> Before, (with previous version)  I succeded without problems to link via OGR-ODBC to a Database Access 2000: Now I have always a white screen with a msg error (...)
> I tried to read all msg in maplab List, Wiki about following topics:  ogr-connection-ovf file-odbc-maplab-virtualSpatialData-
> 
>   In Search Mailing List Archives in http://lists.maptools.org
> 
>   *http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0311/msg00610.html*
> 
>   http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData
> 
>   MsTutorialGuide.doc
> 
> and many others...but without result.I will happy to have some help:
> 
> this is what I have done until now:
> 
> 1---
> I have DSN system sorce: MapLab_AV
> 2---
> In that database there is Tbl_maplab table with x and y coordinate fields.
> 3---
>  my ovf file is :
> <OGRVRTDataSource>
>     <OGRVRTLayer name="Tbl_maplab">
>         <SrcDataSource>ODBC:MapLab_AV</SrcDataSource>
>         <SrcLayer>Tbl_maplab</SrcLayer>
>         <GeometryType>wkbPoint</GeometryType>
>         <GeometryField encoding="PointFromColumns" x="x" y="y"/>
>     </OGRVRTLayer>
> </OGRVRTDataSource>
> 4---
> with ogr2ogr utility I have the following msg:
> 
> ERROR 4: Update access not supported for VRT datasources.
> Had to open data source read-only.
> INFO: Open of 'Tbl_maplab.ovf'
> using driver `VRT' successful.
> 1: Tbl_maplab (Point)
> 
>  and until here it seems to be right!!
> 5---
> my Layer is:
>   LAYER
>     NAME "Tbl_maplab"
>     STATUS ON
>     DATA "Tbl_maplab"
>     TYPE POINT
>     CONNECTIONTYPE OGR
>     CONNECTION "Tbl_maplab.ovf"
>     UNITS METERS
>     SIZEUNITS PIXELS
>     TOLERANCE 0
>     TOLERANCEUNITS PIXELS
>     CLASS
>       STYLE
>         SYMBOL "star"
>         COLOR 88 0 0
>         SIZE 12
>         MINSIZE 10
>         MAXSIZE 100
>       END
>     END
>   END
> 
> 6---
> The ovf file is located in data folder of my project( I tried to copy it in all folder to be sure that path was correct
> but nothing happened)
> 7---
> the final error is the following one:
> 
> DrawMap: MapServer OGR Error: Open failed for OGR connection
> `Tbl_maplab.ovf'. File not found or unsupported format. in
> /maplab/common/wrapper/drawmap.php
> DrawMap: MapServer Image Error: Failed to draw layer named 'mytable'. in
> /maplab/common/wrapper/drawmap.php
> DrawMap: MapServer OGR Error: Open failed for OGR connection
> `Tbl_maplab.ovf'. File not found or unsupported format. in
> /maplab/common/wrapper/drawmap.php
> DrawMap: MapServer Image Error: Failed to draw layer named 'mytable'. in
> /maplab/common/wrapper/drawmap.php
> 
> 8---
> /I will appreciate if someone could me something about it because it is two days I go on to try all possibilities but nothig.
> So now I have decided to ask to you
> //I hope someone can help!
> //And Thanks to everyone for all the great advices///
> 
> Aldo
> 
> --
> Aldo Tocchio
> Geologo
> A.R.P.A. Piemonte
> Dipartimento Biella
> via Trento, 11
> 13900 Biella (BI)
> tel. 015-35813145 - fax 015-35813181
> email: a.tocchio at arpa.piemonte.it
> 
> _______________________________________________
> Maplab-users mailing list
> Maplab-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/maplab-users
>