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

[Julien, Heryk]

Hi Paul,
No I'm using a System DSN as suggested in the Wiki.

Héryk

-----Message d'origine-----
De : Paul Spencer [mailto:pagameba at magma.ca]
Envoyé : Friday, January 23, 2004 6:15 PM
À : Julien, Heryk
Cc : 'Mapserver-users at lists.gis.umn.edu'
Objet : Re: TR: [Mapserver-users] Re: VirtualSpatialData (OGR
Connectiontype)


Heryk

Is it possible that you have created a User DSN instead of a System DSN? 
  Just grasping right now.

Paul

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,

-- 
  -----------------------------------------------------------------
|Paul Spencer                           spencer at dmsolutions.ca    |
|-----------------------------------------------------------------|
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
  -----------------------------------------------------------------