Re: [UMN_MAPSERVER-USERS] OGR connection problem

piero cavalieri Wed, 13 Feb 2008 11:52:01 -0800

I did another mistake on a View. Solved that, now it works (but onlywith views...)


Thanks
Piero.


Piero Cavalieri wrote:

I have found that:

- for blank image: I swapped Latitude and Longitude (when doing copy and 
paste...my mistake...)

-I still have strange behaviour:

        <OGRVRTLayer name="pontiStatali">
        <SrcDataSource>ODBC:xxx/[EMAIL PROTECTED],PONTE</SrcDataSource>
        <GeometryField encoding="PointFromColumns" x="Longitudine" 
y="Latitudine"/>
        <SrcSQL>
            ...
        </SrcSQL>
    </OGRVRTLayer>

This one works.

But if I add another <OGRVRTLayer> node inside <OGRVRTDataSource> node:


<OGRVRTLayer name="pontiProvinciali">
        <SrcDataSource>ODBC:xxx/[EMAIL PROTECTED],PONTE</SrcDataSource>
        <GeometryField encoding="PointFromColumns" x="Longitudine" 
y="Latitudine"/>
        <SrcSQL>
            ...
        </SrcSQL>
    </OGRVRTLayer>

Both doesn't work anymore....and I have error like:

msOGRFileOpen(): OGR error. Open failed for OGR connection `ponti.ovf'.
Failed to find layer 'PontiProvinciali' on datasource 'ODBC:xx/[EMAIL 
PROTECTED],PontiProvinciali

Funny thing, I have the same error on both layers (i.e. "Failed to find layer 
'PontiProvinciali'" also on the other layer, which, alone, works...)

I have the same problem both with <SrcSQL> and using db views + <SrcLayer>
Now I try to put OGRVRTDataSource on different ovf files...

Cheers
 Piero

-----Original Message-----
From: UMN MapServer Users List [mailto:[EMAIL PROTECTED] On
Behalf Of Piero Cavalieri
Sent: mercoledì 13 febbraio 2008 13.26
To: MAPSERVER-USERS@LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] OGR connection problem

-----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

Re: [UMN_MAPSERVER-USERS] OGR connection problem

Reply via email to