-----Original Message-----
From: UMN MapServer Users List [mailto:[EMAIL PROTECTED] On Behalf Of Tamas
Szekeres
Sent: mercoledì 13 febbraio 2008 12.51
To: MAPSERVER-USERS@LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] OGR connection problem
Piero,
It seems the DSN is different in the 2 examples below. Is this intentional?
Yes, xxx, yyy are not real user pass....
You should also make sure that the same gdal dll is actually used by
ogrinfo and mapserver.
Yes, this must be verified, but the point is: with one similar connection it
works, with other no....
Also now I have used separate ovf file, and in .map:
STATUS ON
CONNECTIONTYPE OGR
CONNECTION "ponti.ovf"
DATA "pontiProvinciali"
CLASS
....
....
Now I have no error at all, but returned image is blank.....
Possible it is a SRS problem ?
Thanks
Piero
Best regards,
Tamas
2008/2/13, Piero Cavalieri <[EMAIL PROTECTED]>:
>
>
>
>
> 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
