Re: [UMN_MAPSERVER-USERS] OGR connection problem
Piero,
It seems the DSN is different in the 2 examples below. Is this intentional?
You should also make sure that the same gdal dll is actually used by
ogrinfo and mapserver.
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'
SrcDataSourceODBC:xxx/[EMAIL PROTECTED]/SrcDataSource
SrcLayer dbo.PONTE /SrcLayer
GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/
GeometryTypewkbPoint/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.00, 0.00) - (5146718.20, 1726532.78)
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'
SrcDataSourceODBC:xxx/[EMAIL PROTECTED]/SrcDataSource
SrcLayerdbo.PONTE/SrcLayer
GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/
GeometryTypewkbPoint/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
-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'
SrcDataSourceODBC:xxx/[EMAIL PROTECTED]/SrcDataSource
SrcLayer dbo.PONTE /SrcLayer
GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/
GeometryTypewkbPoint/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.00, 0.00) - (5146718.20, 1726532.78)
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'
SrcDataSourceODBC:xxx/[EMAIL PROTECTED]/SrcDataSource
SrcLayerdbo.PONTE/SrcLayer
GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/
GeometryTypewkbPoint/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
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
SrcDataSourceODBC: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
SrcDataSourceODBC:xxx/[EMAIL PROTECTED],PONTE/SrcDataSource
GeometryField encoding=PointFromColumns x=Longitudine
y=Latitudine/
SrcSQL
...
/SrcSQL
/OGRVRTLayer
Both doesn't work anymoreand 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'
SrcDataSourceODBC:xxx/[EMAIL PROTECTED]/SrcDataSource
SrcLayer dbo.PONTE /SrcLayer
GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/
GeometryTypewkbPoint/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.00, 0.00) - (5146718.20, 1726532.78)
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'
SrcDataSourceODBC:xxx/[EMAIL PROTECTED]/SrcDataSource
SrcLayerdbo.PONTE/SrcLayer
GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/
GeometryTypewkbPoint/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
I did another mistake on a View. Solved that, now it works (but only
with 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
SrcDataSourceODBC: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
SrcDataSourceODBC:xxx/[EMAIL PROTECTED],PONTE/SrcDataSource
GeometryField encoding=PointFromColumns x=Longitudine
y=Latitudine/
SrcSQL
...
/SrcSQL
/OGRVRTLayer
Both doesn't work anymoreand 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'
SrcDataSourceODBC:xxx/[EMAIL PROTECTED]/SrcDataSource
SrcLayer dbo.PONTE /SrcLayer
GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/
GeometryTypewkbPoint/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.00, 0.00) - (5146718.20, 1726532.78)
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'
SrcDataSourceODBC:xxx/[EMAIL PROTECTED]/SrcDataSource
SrcLayerdbo.PONTE/SrcLayer
GeometryField encoding='PointFromColumns' x='Latitudine'
y='Longitudine'/
GeometryTypewkbPoint/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
