TR: [Mapserver-users] Re: VirtualSpatialData (OGR Connectiontype)

[Normand Savard]

Julien,

Is it possible to see the map projection section or if your map file is 
not too long could you copy it here?  Also, could you joined your 
database structure?

Norm

Julien, Heryk wrote:

>Has anyone ever tried connecting to Access 2000?
>That may be the problem.
>Is so I'll have to use a different db software!
>Unfortunatly almost everyone in my office works with Access 2000.
>
>Thank you all for your patience and help
>Cheers
>Héryk
>
>-----Message d'origine-----
>De : Arthur, John [mailto:John.Arthur at T-Mobile.com]
>Envoyé : Friday, January 23, 2004 2:09 PM
>À : 'Julien, Heryk'; 'Frank Warmerdam'
>Cc : 'Zak James'; 'Normand Savard'; 'Mapserver-users at lists.gis.umn.edu';
>Anctil, Martin; 'spencer at dmsolutions.ca'
>Objet : RE: [Mapserver-users] Re: VirtualSpatialData (OGR
>Connectiontype)
>
>
>I'm using windows with MSSQL for this one.  In your CONNECTION tag, try
>using "/" instead of "\":
>"D:/webCGCq/lcnp/mapserver_demo/maritimes/data/shp/geo83/mgwi.ovf"
>
>-----Original Message-----
>From: Julien, Heryk [mailto:hjulien at nrcan.gc.ca]
>Sent: Friday, January 23, 2004 2:03 PM
>To: 'Frank Warmerdam'; Arthur, John
>Cc: 'Zak James'; 'Normand Savard'; 'Mapserver-users at lists.gis.umn.edu';
>Anctil, Martin; 'spencer at dmsolutions.ca'
>Subject: RE: [Mapserver-users] Re: VirtualSpatialData (OGR
>Connectiontype)
>
>
>Okay,
>If run the orginfo with the ODBC connection name (MGWI_TBLLOC) instead of
>the Access table name (tblloc) I get my table content. Thanks.
>
>Now I'm back to the original problem. All the components seem to work
>perfectly but I keep on getting the same error message when I try to draw
>the map:
>
>msDrawMap(): Image handling error. Failed to draw layer named 'MGWI_TBLLOC'.
>
>msOGRFileOpen(): OGR error. Open failed for OGR connection
>`D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf'. File not
>found or unsupported format.
>
>It doesn't seem to find the mgwi.ovf file. I tried both relative and
>absolute paths. I checked my mapfile and everyting seems okay
>
>LAYER
>	NAME "MGWI_TBLLOC"
>	TYPE POINT
>	CONNECTIONTYPE OGR
>	CONNECTION
>"D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf"
>	DATA "MGWI_TBLLOC"
>	STATUS default
>	LABELITEM locid
>	PROJECTION
>		"init=epsg:26920"
>	END #projection
>	CLASS
>		SYMBOL 1
>		SIZE 8
>		COLOR 255 0 0
>		LABEL
>			SIZE MEDIUM
>			TYPE BITMAP
>			COLOR 0 0 0
>		END # end of label
>	END # CLASS
>END # LAYER
>
>
>John, are you using an Access database? Are you working on Linux or Window?
>
>
>Thank you all for your help
>Héryk
>
>mgwi.ovf:
>
><OGRVRTDataSource>
>    <OGRVRTLayer name="MGWI_TBLLOC">
>	<SrcDataSource>ODBC:MGWI_MAPSERVER,tblloc</SrcDataSource> 
> 	<SrcLayer>tblloc</SrcLayer> 
>	<GeometryType>wkbPoint</GeometryType>
>	<GeometryField encoding="PointFromColumns" x="X" y="Y"/> 
>    </OGRVRTLayer>
></OGRVRTDataSource>
>
>
>
>
>-----Message d'origine-----
>De : Frank Warmerdam [mailto:warmerdam at pobox.com]
>Envoyé : Friday, January 23, 2004 10:24 AM
>À : Julien, Heryk
>Cc : 'Zak James'; 'Arthur, John'; 'Normand Savard';
>'Mapserver-users at lists.gis.umn.edu'; Anctil, Martin;
>'spencer at dmsolutions.ca'
>Objet : Re: [Mapserver-users] Re: VirtualSpatialData (OGR
>Connectiontype)
>
>
>Julien, Heryk wrote:
>  
>
>>Hi,
>>I tried it and I don't get the table content!
>>
>>Firt try:
>>D:\WebScripts\MapServer>ogrinfo
>>D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf
>>
>>ERROR 4: Update access not supported for VRT datasources.
>>Had to open data source read-only.
>>INFO: Open of
>>`D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf'
>>using driver `VRT' successful.
>>1: MGWI_TBLLOC (Point)
>>
>>
>>
>>Second try with the table name:
>>D:\WebScripts\MapServer>ogrinfo
>>D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf tblloc
>>
>>ERROR 4: Update access not supported for VRT datasources.
>>Had to open data source read-only.
>>INFO: Open of
>>`D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf'
>>using driver `VRT' successful.
>>
>>
>>
>>The table doesn't seem to be coming through! Any idea?
>>
>>I tried the new build that Paul made available this morning and I get the
>>same problem! 
>>    
>>
>
>Hi,
>
>I'm not sure if I missed some of the email on this thread (it is pretty
>overwhelming!) but you didn't use the correct table name in your ogrinfo
>query.  When you ran ogrinfo without the layer name you got "1: MGWI_TBLLOC
>(Point)" as the result.  The "MGWI_TBLLOC" portion of this is the layer
>name.  So you should use it, not TBLLOC as the layer name in your ogrinfo
>query:
>
>Good luck,
>  
>