[Gdal-dev] ogr virtual data issues with connecting to excel

[Kralidis,Tom [Burlington]]

> -----Original Message-----
> From: Normand Savard [mailto:nsavard at dmsolutions.ca] 
> Sent: Monday, February 16, 2004 9:13 AM
> To: gdal-dev at remotesensing.org
> Subject: Re: [Gdal-dev] ogr virtual data issues with 
> connecting to excel
> 
> 
> Tom,
> 
> You could verify your connection with the Excel driver by using this 
> small application:  ODBCView:
> 
> http://asia.cnet.com/downloads/pc/swinfo/0,39000587,39034753s,00.htm
>

Thanks for the info.  Frank is currently debugging. 

> 
> Norm
> 
> Kralidis,Tom [Burlington] wrote:
> 
> >Hi,
> >
> >I'm trying to connect to an excel document using this 
> approach, but am 
> >having problems doing so.
> >
> >I have created a system DSN
> >
> >Here is my .ovf file:
> >
> ><OGRVRTDataSource>
> >	<OGRVRTLayer name="plantwatch">
> >		
> <SrcDataSource>ODBC:plantwatch2,plantwatch</SrcDataSource>
> >		<SrcLayer>plantwatch</SrcLayer>
> >		<GeometryType>wkbPoint</GeometryType>
> >		<LayerSRS>WGS84</LayerSRS>
> >		<GeometryField encoding="PointFromColumns" 
> x="longitude" 
> >y="latitude"/>
> >	</OGRVRTLayer>
> ></OGRVRTDataSource>
> >
> >When I test with ogrinfo, I get:
> >
> >C:\ms4w\Apache\cgi-bin\ms_odbc>.\ogrinfo.exe
> >\ms4w\mapserv\services\naturewatch\plantwatch2.ovf
> >ERROR 4: Update access not supported for VRT datasources. ERROR 1: 
> >Unable to identify source X or Y field for PointFromColumns encoding.
> >FAILURE:
> >
> >Any suggestions?  The x and y attributes exist as columns in 
> my excel 
> >file. As a workaround, when I converted the excel file to an access 
> >database, it worked.
> >
> >I can post the excel document on request.
> >
> >Thanks
> >
> >..Tom
> >
> >=========================
> >Tom Kralidis
> >Systems Scientist
> >Environment Canada
> >Tel: +01-905-336-4409
> >http://www.ec.gc.ca/cise/ 
> >_______________________________________________
> >Gdal-dev mailing list
> >Gdal-dev at remotesensing.org 
> >http://remotesensing.org/mailman/listinfo/gdal-dev
> >
> >  
> >
> 
> _______________________________________________
> Gdal-dev mailing list
> Gdal-dev at remotesensing.org 
> http://remotesensing.org/mailman/listinfo/gdal> -dev
>