Hi all,
I have a problem with OGR layer.
In map file:
...
...
CONNECTIONTYPE OGR
CONNECTION "
<OGRVRTDataSource>
<OGRVRTLayer name='pontiProvinciali'>
<SrcDataSource>ODBC:xxx/[EMAIL PROTECTED]</SrcDataSource>
<SrcLayer> dbo.PONTE </SrcLayer>
<GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/>
<GeometryType>wkbPoint</GeometryType>
<SrcSQL>
select DENOMINAZIONE_UFFICIALE + ' (' + IDENTIFICATIVO + ')'
as Etichetta, Latitudine, Longitudine from PONTE where IDENTIFICATIVO
like 'SP%'
</SrcSQL>
</OGRVRTLayer>
</OGRVRTDataSource>"
CLASS
...
...
Testing connection with ogrinfo is ok (connection ok, all features
returned):
Layer name: pontiProvinciali
Geometry: Point
Feature Count: 524
Extent: (0.000000, 0.000000) - (5146718.200000, 1726532.780000)
Layer SRS WKT:
(unknown)
Etichetta: String (231.0)
Latitudine: Real (10.2)
Longitudine: Real (10.2)
OGRFeature(pontiProvinciali):0
Etichetta (String) = rio Merdar (SP 1 km 0.638 )
Latitudine (Real) = 5100693.00
Longitudine (Real) = 1672733.00
POINT (5100693 1672733 0)
OGRFeature(pontiProvinciali):1
...
...
But with mapserver, in log:
Wed Feb 13 10:30:00 2008,1364,127.0.0.1,TRENTINO,0,1601927.675913
5057438.805019 1739281.629519 5158103.889549,1670604.652716
5107771.347284,DTM ammcmp_grp idro_grp viapri vie srt pontiProvinciali
,msDrawMap(): Image handling error. Failed to draw layer named
'pontiProvinciali'. <br>
msOGRFileOpen(): OGR error. Open failed for OGR connection `
<OGRVRTDataSource>
<OGRVRTLayer name='pontiProvinciali'>
<SrcDataSource>ODBC:xxx/[EMAIL PROTECTED]</SrcDataSource>
<SrcLayer>dbo.PONTE</SrcLayer>
<GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/>
<GeometryType>wkbPoint</GeometryType>
<SrcSQL>
select DENOMINAZIONE_UFFICIALE + ' (' + IDENTIFICATIVO + ')'
as Etichetta'. File not found or unsupported format. <br>
I have also another ovf layer (on SQL Server 2005, with another ODBC
connection), and that one works ok, so I don't understand where's the
problem.
Anyone have some tips ?
Thanks in advance
Piero
