ODBC/OVF connection

[Bart van den Eijnden]

Actually, OVF aka Virtual Spatial Data needs the GDAL_DATA stuff for projections AFAIK (it does not use PROJ files).

I use the following in my MAP file (MAP object) for OVF:

  CONFIG GDAL_DATA /ms4w/apps/stragisweb/gdal_data

and then put the GDAL_DATA files (wkt and csv files) in that path, or choose your own path ofcourse.

GDAL_DATA could also be an environment variable.

Best regards,
Bart

Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BEN at Syncera-ITSolutions.nl

>>> Emil Zegers <taatuut at PLANET.NL> 07/19/05 12:02pm >>>
Hello Piero,

Have you checked if the PROJ folder containing projection files is set up
and available on the production machine too?

Regards,

Emil


-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]On 
Behalf Of Piero Cavalieri
Sent: vrijdag 15 juli 2005 16:41
To: MAPSERVER-USERS at LISTS.UMN.EDU 
Subject: [UMN_MAPSERVER-USERS] ODBC/OVF connection


Hi all,

on my devel machine I successfully connect to a layer via ODBC/OVF
connection. Layer is a MSSQL table on Win2k.

I done the same thing on production machine (Win2003) => problems.

ArchimpXP_SIAT.ovf file:

<OGRVRTDataSource>
    <OGRVRTLayer name="impianti">
        <SrcDataSource>ODBC:xx/xxxx at Archimp_HEIDI</SrcDataSource>
    <SrcLayer>Impianti</SrcLayer>
  <GeometryType>wkbPoint</GeometryType>
  <LayerSRS>epsg:26591</LayerSRS>
  <GeometryField encoding="PointFromColumns"
y="Longitudine"x="Latitudine" />
    </OGRVRTLayer>
</OGRVRTDataSource>

..map file:

LAYER
    GROUP i_dep_grp
    CONNECTION "ArchimpXP_SIAT.ovf"
    CONNECTIONTYPE OGR
    DATA "impianti"
    NAME "impianti"
    METADATA
        "wms_title" "Impianti Depurazione"
        "wms_srs"   "26591"
    END
    PROJECTION
        "init=epsg:26591"
   END
    STATUS ON
....
....

web page:

....
<asp:listitem value=i_dep_grp selected=true>Depurazione</asp:listitem>
....

ODBC connection test:
ogrinfo ODBC:xx/xxxx at Archimp_HEIDI
returns the list of db tables, so seems ok.

Error messages when requesting the web page:

msDrawMap(): Image handling error. Failed to draw layer named 'impianti'.
msOGRFileOpen(): OGR error. Open failed for OGR connection
`Archimp_HEIDI.ovf'. Failed to import LayerSRS `epsg:26591'.
" msDrawMap(): Image handling error. Failed to draw layer named 'impianti'.
msOGRFileOpen(): OGR error. Open failed for OGR connection
`Archimp_HEIDI.ovf'. Failed to import LayerSRS `epsg:26591'.
"


I don't understand if errors occurs during connection open or it's layer
related.

The only difference beteween development environment seems to be that in
production machine data files are in different drive (web application in
C:, data in D:; of course SHAPEPATH is set right).

Help please
  P.